CICA 1994 April/CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO/win3/access/access_l.exe/ACC9311.TXT

Text File | 1994-01-07 | 183KB | 4,194 lines

=========================================================================
Date:         Mon, 1 Nov 1993 05:55:55 SAT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Taha <[e-mail]>
Organization: King Fahd University of Petroleum and Minerals, S.A.
Subject:      registration

Dear Access server
please add my name to your list. I had tried many times to subscribe my
self directly but I could't ...So please help me.
Thanks

Taha
=========================================================================
Date:         Mon, 1 Nov 1993 12:36:05 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Martin Ederveen <[e-mail]>
Organization: Hogeschool Eindhoven
Subject:      Runtime version stories

Hi All,

I'm currently working with the runtime version.
As I have system manager Novell rights, I thought I could do the
installation for users in a distributive way (NOT using the custom
setup program).

The files have been split thus:
Program files in a directory G:\PROGS\HT\ on the fileserver,
Database files in another    H:\DATA\HT.DB\ on the same server.
The user has (via group) accessrights ros to the G: dir and rw to the
database.

The runtime is started thus:
MSARN110 H:\DATA\HT.DB\DB1.MDB /INI G:\PROGS\HT\DB1.INI

In the DB1.INI there is a reference to the location of the used icon.

The problem arises when I refer to an icon on a networkdrive, like
the path G: I used, the icon isn't used. When I refer to a local
drive, say C:\WINDOWS, then it does work. Is this a bug?


I also experience problems with the SYSTEM.MDA location. Where can I
place this? It's a user-dependant file, would there be an other
option but put it in C:\WINDOWS also?


The custom setup wizard doesn't work properly for me. It refuses to
accept (some) network-paths :((

----------------------------------------------------------------------
| ing. Martin W. Ederveen    | "In the future there will be real     |
| Hogeschool Eindhoven       |  thinking machines.                   |
| Postbus 347                |  Yes, but who's thoughts will they    |
| 5600 AH Eindhoven          |  be thinking?"                        |
| tel. [phone]      |                                       |
| fax. [phone]      |  Quotation from Dr.Who:               |
| Email [e-mail] |   The Curse of Fenrick                |
=========================================================================
Date:         Mon, 1 Nov 1993 10:57:47 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Dantin <[e-mail]>
Subject:      Re: Running Totals

Tried it and it worked fine - Thanks!
=========================================================================
Date:         Mon, 1 Nov 1993 09:37:10 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Linda D. Cornell" <[e-mail]>
Subject:      Re: Apt numbers
In-Reply-To:  <[e-mail]>

What I have done when I want a very specific order - on a list that isn't
going to change, is set up the list using a counter as the key, and then
use the counter to do the sorting.  An alternative would be to add a
field called sort_order, which isn't a key, and would allow more
flexibility for future additions, insertions, changes.

Kludgy, but it works!

Linda Cornell
[e-mail]

On Sun, 31 Oct 1993, DARRYL BRAATEN wrote:

> In designing a data base for aptment maintence records we have come
> across a small problem.  In this particular apartment the numbering
> system is not very consistant  the numbers go like this 1,2,3,4a,4b,5,6
> if a alpha field is used to store the numbers apartment 4a will come
> after apt. 40 when it should come after 3.  has anybody come up with a
> solution to this problem before?  It has to be a fairly common problem.
>
> Any help would be very welcome.
> replies can be sent to [e-mail] or reply in the list I read
> it every day (just about any way).
> ttfn
> Darryl Braaten
>
=========================================================================
Date:         Mon, 1 Nov 1993 13:59:56 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Changing the User() and working with C and Access

I am interested in writing a small C++ program for windows (or for that matter
DOS) that can read and write to .MDB files.

Is there something like a Class Library for this, or better yet, can I somehow
use the functions built into Access's DLLs?  using DDe is not good enough for
me.  I don't want to have to use the whole client/server thing.  I want to be
able to distribute my C++ program WITHOUT Access, so that someone can do simple
database manipulation through my application without buying MS Access.

Also, I posted a question about changing the User() without exiting Access.  I
didn't see it on the list, so I'll ask again ...

I am currently writing an application for Access that requires use by different
users at the same station.  My problem is that I cannot change the User()
without closing the database, exiting Access and then restarting Access.

Does anyone know of a way to change the User without exiting the database, or at
least without having to restart the Access Database engine?

Thanks in advance,

Thornton Prime
=========================================================================
Date:         Mon, 1 Nov 1993 14:20:29 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Changing the User() and working with C and Access
In-Reply-To:  <[e-mail]> from "Thornton Prime" at Nov 1,
              93 01:59:56 pm

Thorton,

Re: C++ and Access, get one of the ODBC libraries that are available.  I
believe Q&E in Atlanta and PageAhead in Seattle have product.

John
=========================================================================
Date:         Tue, 2 Nov 1993 08:46:02 GMT
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Paul Snell <[e-mail]>
Subject:      Re: Sorting Apartment Numbers

One solution for sorting the apartment numbers correctly is to
ensure that all the numeric parts of the numbers have the same
number of digits: eg. 01, 02, 02b, 03, 04a, 21, 21b and so on ..
this will then sort without any problems.  Of course, it might
mean a bit of work - but there can't be that many apartments can
there?

Paul

*****************************************************************
***                                                           ***
***  From:  Paul Snell      Email: [e-mail]       ***
***         IT Trainer                                        ***
***         ACS IT Training Centre                            ***
***         University of Birmingham                          ***
***         B15 2TT                                           ***
***         UK                                                ***
***                                                           ***
***         Tel: [phone]   Fax: [phone]             ***
***                                                           ***
*****************************************************************
=========================================================================
Date:         Tue, 2 Nov 1993 07:53:04 CET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         SJA Sys Admin <[e-mail]>
Subject:      Re: Apt numbers

>> In designing a data base for aptment maintence records we have come
>> across a small problem.  In this particular apartment the numbering
>> system is not very consistant  the numbers go like this 1,2,3,4a,4b,5,6
>> if a alpha field is used to store the numbers apartment 4a will come
>> after apt. 40 when it should come after 3.  has anybody come up with a
>> solution to this problem before?  It has to be a fairly common problem.
>>
>> Any help would be very welcome.
>> replies can be sent to [e-mail] or reply in the list I read
>> it every day (just about any way).
>> ttfn
>> Darryl Braaten
>>

I would recommend breaking the apartment number down into two components, a
number field and a suffix field and sort on the combined key of number and
suffix.

Ken Vane
=========================================================================
Date:         Tue, 2 Nov 1993 08:06:07 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Joe White <[e-mail]>
Subject:      Delete userid [e-mail]

HI


Please delete [e-mail] from you mail list.
This id has been deleted.


thanks Postmaster fnma.com
=========================================================================
Date:         Tue, 2 Nov 1993 09:58:42 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Delete userid [e-mail]

%  Please delete [e-mail] from you mail list.
%  This id has been deleted.

I wonder why these guys don't send a "UNSUB *" before they
delete userids...I guess they don't know "laziness is the
mother of invention"... :)
=========================================================================
Date:         Tue, 2 Nov 1993 12:07:35 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Sheryl Smoot <[e-mail]>
Subject:      Queries on Large Databases

     I have an Access database that has a table with over 100,000 records
     in it and have found that the performance I get from my queries is
     miserably slow.  The searches I perform allow for complex AND/OR WHERE
     clauses.  My searches are keyword searches into the name field of the
     table.  I have pulled out all of the keywords from the name field into
     another table and now can join the keyword table to the first table
     (thus eliminating using "Like" in my SQL), but this is still slow.

     Does anyone know of any optimization hints or any books that might be
     useful?

     Thanks!

     Sherry
=========================================================================
Date:         Tue, 2 Nov 1993 13:36:29 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Queries on Large Databases
In-Reply-To:  Message of Tue,
              2 Nov 1993 12:07:35 EST from <[e-mail] SINC.COM>

In practical terms, a 100,000-record .MDB is going to be extremely slow
even though Access will create databases of--what is it?--up to 2 million
records or whatever.

However, you don't mention anything about your system.  Which processor,
what speed, how much RAM, etc?

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Tue, 2 Nov 1993 13:33:53 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Where are field/table descriptions stored?

To all:

I am currently putting together an application to assist me in documenting
my database objects (tables/queries/forms/etc). As part of that, I wish to
transfer table and field description information. I am having trouble
finding these descriptions in the "MS" tables, especially the "field
description" information. Does anyone know where I can find this
information (table, field)? Has anyone else out there worked this issue?

Dave F.
[e-mail]
=========================================================================
Date:         Tue, 2 Nov 1993 10:25:09 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Muenzler <[e-mail]>
Organization: University of Texas Health Science Center at San Antonio
Subject:      Re: Apt numbers

>> In designing a data base for aptment maintence records we have come
>> across a small problem.  In this particular apartment the numbering
>> system is not very consistant  the numbers go like this 1,2,3,4a,4b,5,6
>> if a alpha field is used to store the numbers apartment 4a will come
>> after apt. 40 when it should come after 3.  has anybody come up with a
>> solution to this problem before?  It has to be a fairly common problem.
>>
>> Any help would be very welcome.
>> replies can be sent to [e-mail] or reply in the list I read
>> it every day (just about any way).
>> ttfn
>> Darryl Braaten
>>

As you probably know, text is sorted differently than numeric data.  Elements
are placed in alphabetical order (ASCII).  If you want to have the "numbers"
in numeric order with 4 coming before 4a and then 4b... you must have the
elements right justified in the table.  This will cause the sort routine
to treat them properly as text-numbers so you will won't end up with something
like this:

1
10
11
2
20
3
4
4a
4b
5
6
7
8
9
...

but like this:

      1
      2
      3
      4
     4a
     4b
      5
      6
      7
      8
      9
     10
     11
     20
...

Your macros or program can do whatever with the elements after they are
retrieved, but they should be stored RIGHT JUSTIFIED in the table(s).

                        Later...
                Kevin Muenzler
                        [e-mail]
=========================================================================
Date:         Tue, 2 Nov 1993 12:22:52 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Record Locks On Netware
In-Reply-To:  <[e-mail]>; from "Phil Paxton" at Sep 8,
              93 12:20 pm

I've been importing data files from our Netware server.

Everything has been fine, but today Novell is
complaining about record lock violations.

I remember reading about setting the lock limit
somewhere, but can't find it.

Can anybody help?

Thanks.
=========================================================================
Date:         Tue, 2 Nov 1993 21:33:50 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Queries on Large Databases

There is a newsletter put out by the COBB group.  Several of the issues
deal with how to optomize queries.  Perhaps you might find a back issue
somewhere.

------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date:         Wed, 3 Nov 1993 08:39:41 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Arman Rivard <[e-mail]>
Subject:      Access and NOVELL

 This might be a FAQ but...

   I am finally ready to go online with the database. I am setting up Novell
   3.11. Do I need Windows for Workgroups? Who takes care of the file locking?
   Where do I find info about this.

   Thanks for any help.

--

Arman Rivard         How do Peabody and Sherman get back ?
<[e-mail]>
=========================================================================
Date:         Wed, 3 Nov 1993 09:04:11 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Where are field/table descriptions stored?

% I am currently putting together an application to assist me in documenting
% my database objects (tables/queries/forms/etc). As part of that, I wish to
% transfer table and field description information. I am having trouble
% finding these descriptions in the "MS" tables, especially the "field
% description" information. Does anyone know where I can find this
% information (table, field)? Has anyone else out there worked this issue?

Turn on the viewing of system objects and you'll see the series of
elements prefixed by "MSys...".  Also, you might want to look at
the code in the Access Analyzer library for some ideas about how
to look at this stuff.

phil

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Wed, 3 Nov 1993 09:11:23 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Queries on Large Databases

% I have an Access database that has a table with over 100,000 records
% in it and have found that the performance I get from my queries is
% miserably slow.  The searches I perform allow for complex AND/OR WHERE
% clauses.  My searches are keyword searches into the name field of the
% table.  I have pulled out all of the keywords from the name field into
% another table and now can join the keyword table to the first table
% (thus eliminating using "Like" in my SQL), but this is still slow.

% Does anyone know of any optimization hints or any books that might be
% useful?

The two easiest ones are 1) indexing; and 2) you probably don't
have anything like this but look for redundant tests -- this is
a problem not only for databases, but coding in general -- since
it appears you are working in SQL source instead of QBE, you might
want to check again.  I'm referring to the obvious things like

   if FName = Joe and LName = Smith or
      FName = Tim and LName = Smith

instead of
   if LName = Smith And ( FName = Joe or Tim )

scenarios as well as the more complicated ones.  I realize I've
oversimplified here a little, but since we have an audience of
varying levels...


FWIW, I've already put my $0.02 in for a chapter on Access
Performing and Tuning on a future edition of "Access Developer's
Guide".

cheers.

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Wed, 3 Nov 1993 12:11:09 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Linda D. Cornell" <[e-mail]>
Subject:      The Knowledge Base

Hi there,
I ftp'd the knowledge base the other day, but I can't get it to unzip
using PKUNZIP.EXE.  Does anyone have any alternate unzipping programs
that they can suggest?

Thanks in advance!

Linda Cornell
[e-mail]
=========================================================================
Date:         Wed, 3 Nov 1993 16:43:06 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: The Knowledge Base
In-Reply-To:  Message of Wed,
              3 Nov 1993 12:11:09 -0800 from <[e-mail] TON.EDU>

If you ftp'd that KB out of the Access directory on CICA, it is zipped
with PKZIP 2.04g.  You won't be able to unzip it with PKUNZIP 1.10.

I think PKZIP 2.04g is also available somewhere on CICA.

Nathan

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 3 Nov 1993 18:50:50 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      The Knowledge Base

% I ftp'd the knowledge base the other day, but I can't get it to unzip
% using PKUNZIP.EXE.  Does anyone have any alternate unzipping programs
% that they can suggest?

Did you remember to FTP it with BINARY ?
=========================================================================
Date:         Wed, 3 Nov 1993 14:56:06 LST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Scott Selk <S=[e-mail]>
Subject:      LIST BOX TO SELECT MACRO

I am trying to use a 4 item list box to run a macro out of a macro group.
However when the macro runs it says "macro"not found"

ex. if you pick computers from the list it would trap the selection and pass
it on as the macroname selection.computers to the macrogroup.

If this makes sense to anybody and you can help plz post to list or me
personally as I read the list daily.

+---------------------------------------------+
|   SCOTT D. SELK, ALASKA AIR GUARD           |
|   BLDG 3126 STE 1, EIELSON AFB, AK 99702    |
|   INTERNET:[e-mail]           |
|   PHONE: [phone] FAX:[phone]    |
+---------------------------------------------+
=========================================================================
Date:         Wed, 3 Nov 1993 21:52:58 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         George Raudabaugh <[e-mail]>
Subject:      Re: The Knowledge Base

Did the naming stuff get resolved?  I seem to remember that this was
actually a self-extracting archive (a .EXE) but cica had renamed it
to .ZIP.

GR.
=========================================================================
Date:         Wed, 3 Nov 1993 22:34:40 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: The Knowledge Base
In-Reply-To:  Message of Wed,
              3 Nov 1993 21:52:58 -0500 from <RAUDABAUGH@IDICL1. IDI.OCLC.ORG>

No...that was my too-hasty analysis of the situation.  *blush*  There is
NOT a naming problem.  Here's what happened:

Apparently what happened at that time was that I put the February version
of the KB up on CICA in the uploads area--specifically pub/pc/win3/uploads/
JUN93.  Also in June, there was another KB upgrade which someone put into
the pub/pc/win3/access directory.  I <thought> at the time that they had
simply moved the self-dissolving archive that <I> uploaded into the
Access directory and had somehow managed to rename it to a .ZIP extension.
This was <NOT> the case.  The CICA managers put me right on this after I
asked them about it and I'm pretty sure I announced that to the list
right after they told me.  I subsequently downloaded the NEWER KB from
the access directory and found that it was a PKZIP v2.04g archive (the
hard way--it wouldn't unzip on my copy of 1.10 at work, but did on the
my copy of 2.04g at home).

Moral of the story:  Get the KB out of the Access directory because it's
newer than the one I originally uploaded, and upgrade to PK 2.04g so
you can extract it.  (Why it wasn't put up in a self-dissolving archive
is beyond me...)

Hope this clears that up.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 3 Nov 1993 22:21:00 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Glen D Moffitt <[e-mail]>
Subject:      Re: The Knowledge Base
In-Reply-To:  <[e-mail]>

You did not state what if any error messages you may have been getting
when you tried to unzip, but you are probably using an earlier version of
pkunzip on a file that has been zipped with a later version of pkzip.  The
latest version is I think 2.04g and is available off of almost any bbs.  I
see from your address you might be in the Seattle area?  If you need them,
I can give you some numbers of some good bbs's.

  Glen
=========================================================================
Date:         Wed, 3 Nov 1993 23:54:48 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Where are field/table descriptions stored?
In-Reply-To:  <[e-mail]> from "Phil Paxton" at Nov 3,
              93 09:04:11 am

There is a product by the name of Total Access that will do all of this
for you.  It is < $200, and available from FMS.  Phone [phone], FAX
703-448-3861.  We have used it, and it does a very thorough job.

John
=========================================================================
Date:         Thu, 4 Nov 1993 02:15:29 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pete Fanning <[e-mail]>
Subject:      Labels and Access

Forgive me, but I'm not all that familiar with ACCESS, although
I'm learning as I go along.

My problem is this:  I'm working on a Video Tape database and I'm
trying to produce labels for these tapes based on the data in my
database.  I have the report setup, but I'm having problems
with one aspect of the task.

On any given label, I can only fit 4 programs per label.  My problem
is how to tell ACCESS to move to the next label if there are more
than 4 programs.  I have tried to set up something by clicking on
"Sorting and Grouping", but I'm not having any success.

My theory is I may have to define a function that I can insert in
the Sorting and Grouping box to perform this task, but I have no
idea how to proceed.

Has anyone done anything similar to what I'm talking about, or
know enough about ACCESS to point me in the right direction?

I'd be most appreciative!  Thanks!

Pete Fanning
Internet: [e-mail]
=========================================================================
Date:         Thu, 4 Nov 1993 09:44:00 MET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Gran Petersson <[e-mail]>
Subject:      Software for group-planning.

I am looking for a software for planning a group of people. I am not going
to build The Empire State building so I dont need MS Project and that kind
of stuff.
I just want to put in the different kind of jobs with some parameters and
who is responsible and want to know when the next employee is free for a new
task and when can we take up new task and that kind of things.

I have tried som calender-software and group-software like Schedule, Task
Timer and so on but no, it is not the right thing.

Anyone who has an idea?

Regards,

Goran Peterson
[e-mail]


______________________________________________________________________

  Goran Peterson                 Tel:   [phone]
  Microfront Vaxjo AB           Fax:    [phone] ([phone] home)
  P G Vejdes vag 15
  S-352 52  VAXJO
  SWEDEN

  Internet:    [e-mail]
  Memonet/SIL: ERI.VAX."GORAN%MFSVINX..MAIL.SWIP.NET"..INET..EDS
______________________________________________________________________
=========================================================================
Date:         Thu, 4 Nov 1993 07:21:19 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Labels and Access

% On any given label, I can only fit 4 programs per label.  My problem
% is how to tell ACCESS to move to the next label if there are more
% than 4 programs.  I have tried to set up something by clicking on
% "Sorting and Grouping", but I'm not having any success.

% My theory is I may have to define a function that I can insert in
% the Sorting and Grouping box to perform this task, but I have no
% idea how to proceed.

% Has anyone done anything similar to what I'm talking about, or
% know enough about ACCESS to point me in the right direction?

Have you tried looking at the output options available with the
Report Wizard.  There are a ton of predefined labels -- it's much
better to see if there's something built-in which will solve your
problem than to go through the hassles of writing extra code.

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Thu, 4 Nov 1993 07:24:27 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      PKZIP / was Re: The Knowledge Base

% Did the naming stuff get resolved?  I seem to remember that this was
% actually a self-extracting archive (a .EXE) but cica had renamed it
% to .ZIP.

CICA renamed it .ZIP or someone uploaded it as .ZIP?
=========================================================================
Date:         Thu, 4 Nov 1993 07:26:44 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: The Knowledge Base

% can extract it.  (Why it wasn't put up in a self-dissolving archive
% is beyond me...)

I'm figuring either someone repackaged PKZIP (a pet peeve -- people
who FTP or d/l something, then reorganize because they don't know
what the #)$&*#) they are doing) or CICA personnel somehow thinking
no one wants a .EXE....
=========================================================================
Date:         Thu, 4 Nov 1993 06:30:12 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pete Fanning <[e-mail]>
Subject:      Re: Labels and Access
In-Reply-To:  In reply to your message of THU 04 NOV 1993 06:21:19 CST

> Have you tried looking at the output options available with the
> Report Wizard.  There are a ton of predefined labels -- it's much

I'll take another look, but I don't remember seeing too much
flexability with labels in Report Wizard (that is how I created
my initial label format).

I have no problem with the label FORMAT.  It's how I tell ACCESS
to go to the next label after 4 records that's the problem.  I
don't think Report Wizard will do this for me, but, like I said,
I'll take another look.  Thanks for responding, Phil.

Pete Fanning
Internet: [e-mail]
(born at Methodist Hospital, raised in good 'ole Indy,
 now living in Milwaukee, WI)
=========================================================================
Date:         Thu, 4 Nov 1993 14:26:48 +0200
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Info-Disk LTD." <[e-mail]>
Subject:      Re: Software for group-planning.
In-Reply-To:  <[e-mail]>

Hi, Goran!
I'm not completely sure, however you could try EAZYPROJECT (ezprj402.zip)
software, it is available for example from OAKLAND SIMTEL
(OAK.oakland.edu), directory /pub/msdos/flowchart.
Good luck!

Sergey Rudenko

Tel [phone], fax [phone]
    [phone] (home)
=========================================================================
Date:         Thu, 4 Nov 1993 08:36:31 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         DARRYL BRAATEN <[e-mail]>
Subject:      Thanks

Thanks for all the sugestions for organising the apt numbers.  The
working solution was to use two fields one for then number one for the
letter and use a dash for the apts with out a letter.   Thanks
TTFN
=========================================================================
Date:         Thu, 4 Nov 1993 12:20:55 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Louis M. Swiczewicz" <[e-mail]>
Subject:      The Knowledge Base

Question:

Is there an updated version of ACC-KB?  The ACC-KB.zip file located
in the access directory was last modified June '93.  Is there a
newer version located at a FTP site?

Microsoft does maintain an anonymous FTP site that includes
Knowledge Bases for most of their products including Access.  The
Access KB for the most part includes nearly identical information
to that found in the ACC-KB.  However, files have to be
individually retrieved.

Besides the Knowledge Bases, Microsoft also has a softlib which
includes a number of drivers and other goodies.

FTP to GOWINNT.MICROSOFT.COM  (IP = 198.105.232.1)

To get to the Access Knowledge Base, CD deskapps/access/kb.  One
should use the get command to retrieve the index.txt file.  The
index includes descriptions for the Information sheets.
=========================================================================
Date:         Thu, 4 Nov 1993 14:13:53 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      The Knowledge Base

% From: "Louis M. Swiczewicz" <[e-mail]>
% Question:
% Is there an updated version of ACC-KB?  The ACC-KB.zip file located
% in the access directory was last modified June '93.  Is there a
% newer version located at a FTP site?

According to the archives on Compu$erve, the most current KB is
dated 10-11 and the summary states the cutoff date was 09/23/93.

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Thu, 4 Nov 1993 23:29:18 -0800
Reply-To:     Kael Fischer <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kael Fischer <[e-mail]>
Subject:      Out of Memory? NO WAY!!

When I paste a link from a Word for Windows document to an object frame on
an MS Access form I get OUT OF MEMORY messages from both Word and Access.

Now I would think that this is a reasonable condition except:
        1) I just got a new 486/66 with 8MB of memory, and this operation
worked fine with my 386sx/16 that only had 6MB of RAM.
        2) I use the same shells in both cases (PC-TOOLS).  The CPS System
Consultant reports that I have MORE memory (both physical and virtual) on
the new machine than the old one.
        3)  The documents I am linking are often very small.

Why am I getting these messages?  Can you offer any advice?


Virtually,
Kael Fischer

[e-mail]
=========================================================================
Date:         Fri, 5 Nov 1993 07:54:57 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: The Knowledge Base
In-Reply-To:  <[e-mail]> from "Louis M. Swiczewicz" at
              Nov 4, 93 12:20:55 pm

The latest copy of the Knowledge Base also includes a find function that
allows you to search all text in the database, and look for combinations
of terms.

John
=========================================================================
Date:         Fri, 5 Nov 1993 08:15:08 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Labels and Access
In-Reply-To:  <[e-mail]> from "Pete Fanning" at Nov 4,
              93 02:15:29 am

Pete,

Build your report from a query.  Add two fields to the query, a counter
and a derived field.  Use a function for the derived field.  Code the
function something like:

If counterfield mod 4 = 1 then
    derivedfield = derivedfield + 1
else
    derivedfield doesn't increment
endif

Your output should look like:

Counter  Derived
1          1
2          1
3          1
4          1
5          2
....

Then group on the derived field.

John
=========================================================================
Date:         Fri, 5 Nov 1993 11:16:44 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: The Knowledge Base
In-Reply-To:  Message of Fri,
              5 Nov 1993 07:54:57 -0800 from <[e-mail] M>

It has also grown to be quite large.  I saw two different copies of it
on CompuServe last night, one at (as I recall) 1.2MB and one at 1.5MB.
I didn't download it because I was on my sister's account and didn't
want to load up her bill...even at 9600 baud it said 30 minutes to down-
load it.

Do our friends at Microsoft have any thoughts on why the help file version
isn't available for ftp from their server?

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 5 Nov 1993 08:22:59 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: LIST BOX TO SELECT MACRO
In-Reply-To:  <[e-mail]> from "Scott Selk" at Nov 3,
              93 02:56:06 pm

Scott,

You need to run a single macro in the On Exit property of the list box.
It would use contitionals in the macro to examine the value in the list
box, and then run other macros in response to the values.

Hope this helps.

John
=========================================================================
Date:         Fri, 5 Nov 1993 08:40:18 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: The Knowledge Base
In-Reply-To:  <[e-mail]> from "Nathan Brindle" at Nov 5,
              93 11:16:44 am

The two files Nathan refers to are ACC-KB.ZIP and ACC-IN.ZIP.  ACC-IN is
the find engine I referred to in a previous post.  You need it to be
able to search all articles for words and combinations of words.  Both
need to be downloaded.

John
[e-mail]
=========================================================================
Date:         Fri, 5 Nov 1993 12:09:44 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: The Knowledge Base
In-Reply-To:  Message of Fri,
              5 Nov 1993 08:40:18 -0800 from <[e-mail] M>

Aha!  That was not clear from my reading of the descriptions (admittedly
I was in a hurry).  Thanks for the clarification.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 5 Nov 1993 11:52:09 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: The Knowledge Base

     Would someone who has the new Knowledgebase .ZIP files mind
     putting them somewhere where us poor CompuServe-less people
     could get it.

     It would be great if MS would put it at ftp.microsoft.com.
     Until that happens, maybe someone wouldn't mind downloading
     it to FTP.CICA.INDIANA.EDU.  They have some of the older KB
     files, but I think their most recent is August.

     TIA,

     Thornton Prime
=========================================================================
Date:         Fri, 5 Nov 1993 14:37:38 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Whattam I Bid? / Was: Re: The Knowledge Base

%  From:        Thornton Prime, INTERNET:
%     "Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU
%  Would someone who has the new Knowledgebase .ZIP files mind
%  putting them somewhere where us poor CompuServe-less people
%  could get it.

%  It would be great if MS would put it at ftp.microsoft.com.
%  Until that happens, maybe someone wouldn't mind downloading
%  it to FTP.CICA.INDIANA.EDU.  They have some of the older KB
%  files, but I think their most recent is August.

How many of my books would you be willing to buy in return? :)
:)

On a serious note, I'll put it on my list of things to try to do
before I leave.  My 9600 baud modem is here at work, so it's
to my advantage to d/l the Compu$erve stuff from here.  Unfortunately,
I only have a 2400 hookup via provider to Internet (maybe I'll try
FTPMAIL? nah :) )

Anyways, let me see what I can arrange.

phil

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Fri, 5 Nov 1993 16:44:46 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: Whattam I Bid? / Was: Re: The Knowledge Base

% Phil, I can pull it down at 9600 and ftp it right up into CICA or
% wherever.  I just didn't want to do it on my sister's account (and I
% think Microsoft could go to the trouble of putting it in their ftp
% archive anyway!).  Although CICA is closed to uploads at the moment,
% to my recollection.

Since it was going to take awhile at 9600, I was going to go ahead
and do it since my Compu$erve account is via work.

As far as CICA being closed for uploads -- Since CICA is mirrored,
a mirror site could take the upload and when the sites
resynchronize, CICA would pick it up from the mirror site.

phil
---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
=========================================================================
Date:         Fri, 5 Nov 1993 19:50:14 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Knowledge Base
In-Reply-To:  <[e-mail]> from "Phil Paxton" at Nov 5,
              93 02:37:38 pm

I put in a request to Microsoft PSS last night to put the current
Knowledge Base on their ftp site.

John
[e-mail]
=========================================================================
Date:         Mon, 8 Nov 1993 12:41:29 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Organization: University of Texas Health Science Center at San Antonio
Subject:      Out of Memory error.

I have a VERY large database (578K records) that takes up about 70MB of disk spa
   ce.
When setting up relationships that enforce referencial integrety, the machine ru
   ns out
of memory.  I have a 486DX-33 with 8MB of memory and a 24MB swap file running Wi
   ndows
for Workgroups 3.1 (1GB drive, 400MB free).  I know that Access will handle 2 mi
   llion+
records.  Also, any lookup on a keyed field is VERY sssllllloooowww.  It takes s
   everal
seconds to find the 10th record in the file or 100000th record.  Any ideas?????

                Thanks in advance
                        Kevin Muenzler
                                [e-mail]
=========================================================================
Date:         Tue, 9 Nov 1993 16:22:06 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Martin Ederveen <[e-mail]>
Organization: Hogeschool Eindhoven
Subject:      Runtime version stories

Hi All,

----------------------------------------------------------------------
I thought I posted this before but I didn't notice any replies, maybe
anyone out there who can shed some light on problems mentioned below?
----------------------------------------------------------------------

I'm currently working with the runtime version.
As I have system manager Novell rights, I thought I could do the
installation for users in a distributive way (NOT using the custom
setup program).

The files have been split thus:
Program files in a directory G:\PROGS\HT\ on the fileserver,
Database files in another    H:\DATA\HT.DB\ on the same server.
The user has (via group) accessrights ros to the G: dir and rw to the
database.

The runtime is started thus:
MSARN110 H:\DATA\HT.DB\DB1.MDB /INI G:\PROGS\HT\DB1.INI

In the DB1.INI there is a reference to the location of the used icon.

The problem arises when I refer to an icon on a networkdrive, like
the path G: I used, the icon isn't used. When I refer to a local
drive, say C:\WINDOWS, then it does work. Is this a bug?


I also experience problems with the SYSTEM.MDA location. Where can I
place this? It's a user-dependant file, would there be an other
option but put it in C:\WINDOWS also?


The custom setup wizard doesn't work properly for me. It refuses to
accept (some) network-paths :((

----------------------------------------------------------------------
| ing. Martin W. Ederveen    | "In the future there will be real     |
| Hogeschool Eindhoven       |  thinking machines.                   |
| Postbus 347                |  Yes, but who's thoughts will they    |
| 5600 AH Eindhoven          |  be thinking?"                        |
| tel. [phone]      |                                       |
| fax. [phone]      |  Quotation from Dr.Who:               |
| Email [e-mail] |   The Curse of Fenrick                |
=========================================================================
Date:         Tue, 9 Nov 1993 16:02:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Subform Parameter Query

O.K....here it goes..I'll try to keep it simple....

I have a report that is based on a parameter query. Lets say that the parameter
is equal to "A"
The report lists question numbers 1-30 and associated data etc.

Also on this report is a subreport that links with the question
numbers on the main.....and when I produce the report everything works
o.k.......but I now have the need to base the subreport on a
a particular parameter. It happens that the subreport must also be based
on parameter value "A".

So I entered a parameter query in the query that is used for the subreport.
The main report works fine, and
when I produce the parameter query for the subreport, it works fine
by itself, however it fails when it runs as part of the main report.
This is how it fails:
When the main report reaches the point of the subreport, the subreport queries
me for the parameter value."A"(as it should) but then it prompts me for it
again ...and again...and again.
Does Access have problems with parameter queries used as subreports?
Or is it more likely I have a problem with my design?
I have spent hours tying to solve this bug!

==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Tue, 9 Nov 1993 19:46:02 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Information Systems for Decisions <[e-mail]>
Subject:      MS-Access and Oracle and Vax...?

I'm considering the development of a Database using MS-Access
or Visual Basic as the front-end to an Oracle database on a Vax
node using Oracle SQL*Net to attach to the information.  I would
like to hear from others having tried this and the problems encountered
along the way.  Please send you replies to my E-mail address unless
you feel your information would also be of benefit to the rest
of the list.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      "The views expressed here are my own, not AECL Research Company."

Frank C. Brown                                   Voice: [phone] 6195
Business and Information Systems                   Fax: [phone]
AECL Research Company
Chalk River Laboratories                      Bitnet: [e-mail]
Chalk River, Ontario, Canada                Internet: [e-mail]
K0J 1J0

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=========================================================================
Date:         Wed, 10 Nov 1993 12:10:47 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         RON APLAND AH204 <[e-mail]>
Organization: Malaspina College
Subject:      Updating other fields in a record from a form.

I have a form that takes registration information.  I would like to
update, from the form,  two other fields in the record from an entry into
a date field - the person's birthdate.  The two other fields are both
integer fields, one taking a variation of the person's age (age as of a
particular date) and the other a category based on the person's age.

I have tried functions and macros to accomplish this task but have
had no luck.  Functions or subroutines give me an "expected end of
line" error if I try to use the SQL update function from it, a macro
will not accept the contents of variables I set in the function (set
Global) and if I manually enter the information it finds the record
locked (by the form I guess) and won't update it.

It would appear I'm looking under the wrong lamp post.  Any help
would be appreciated.

One other point that may clarify this.  Our network supervisor still has
not put Access 1.1 on the server so I am working from Access 1.0
This is supposed to change in a week or so.

Ron
=========================================================================
Date:         Wed, 10 Nov 1993 16:05:59 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         PROTECT THE RIGHT-KEEP & ARM BEARS <[e-mail]>
Subject:      training materials for access...

Greetings:

I'm a very new user of access, and next spring I will be responsible for
training a dozen or so new users.  Do any of you know of any supplemental
training materials for helping us to learn access better?  In particualr, a
videotape, or a book with exercises and accompanying disk etc.

We have the documentation that came with access, but as a trainer we need
something to work into our own materials.  Any third party leads would be most
appreciated.  Thanks

Cindy Stone

**************************************    Says a student, "So
| Cindy Stone, Training Specialist   |    how many afternoons
| Indiana University - Bloomington   |    do you think it will take
| Department of Physical Plant       |    me to learn tabletop publishing?"
| Bitnet:    STONEC@iubacs           |     __
| Internet:  [e-mail]  |   /                 __
|                                    |  |      *  |\   |  |  \  \   /
| SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
|             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
**************************************   \ __  |  |   \|  |__/    |
=========================================================================
Date:         Wed, 10 Nov 1993 16:15:11 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         PROTECT THE RIGHT-KEEP & ARM BEARS <[e-mail]>
Subject:      adding fields inside a record

As I mentioned earlier, I'm really green about access.  After pouring thru the
literature that came with disks, how can I add two fields INSIDE a record.

For example:  Hotel + AirFare + Per Diem + TRansportation + MIsc = NEW FIELD

Do I create the new field, and then go into a query and put in all of the
fields to add up to a total new field called TOTAL TRAVEL COST?

It seems that Query only adds running totals from multiple records and gives me
a total dollar amount at the tbottom of the report for all the records.  I want
totals inside a record as a new field.

Thanks -- reply  privately if desired, I know I should RT*M, and I've tried...
But hey it's only been a couple of weeks of my new relationship with access.

cindy stone

**************************************    Says a student, "So
| Cindy Stone, Training Specialist   |    how many afternoons
| Indiana University - Bloomington   |    do you think it will take
| Department of Physical Plant       |    me to learn tabletop publishing?"
| Bitnet:    STONEC@iubacs           |     __
| Internet:  [e-mail]  |   /                 __
|                                    |  |      *  |\   |  |  \  \   /
| SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
|             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
**************************************   \ __  |  |   \|  |__/    |
=========================================================================
Date:         Wed, 10 Nov 1993 13:49:23 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Richardson <[e-mail]>
Subject:      Re: training materials for access...

I had heard that MS was working on a video tape, but, I have not heard (read)
any more on it.  IF SOMEONE FROM MS IS READING THIS LIST could you please fill
us in?????

GAT d--(++) p c++++ l? u e*(+) m* s/+ n+ h- f? g+(-) w-(+) t++ r+ y++(*)
* James Richardson             *           Normal Disclaimer           *
* - Tech Extraordinary  :}  US *  My opinions belong to my Right Brain *
* Canon Information Systems  N *   Those of my Left Brain might differ *
* 4009 Miranda Avenue        A *    CIS can speak for itself !         *
* Palo Alto CA  94304-1218   I *****************************************
* 415-852-2090    <== VOICE  L *  [e-mail]     <== EMAIL   *
* 415-852-2070    <== FAX      *  WTMR52B                  <== PRODIGY *
***************************** DONT PANIC *******************************




______________________________ Reply Separator _________________________________
Subject: training materials for access...
Author:  [e-mail] at cis-ccsmtp
Date:    11/10/93 4:05 PM


Greetings:

I'm a very new user of access, and next spring I will be responsible for
training a dozen or so new users.  Do any of you know of any supplemental
training materials for helping us to learn access better?  In particualr, a
videotape, or a book with exercises and accompanying disk etc.

We have the documentation that came with access, but as a trainer we need
something to work into our own materials.  Any third party leads would be most
appreciated.  Thanks

Cindy Stone

**************************************    Says a student, "So
| Cindy Stone, Training Specialist   |    how many afternoons
| Indiana University - Bloomington   |    do you think it will take
| Department of Physical Plant       |    me to learn tabletop publishing?"
| Bitnet:    STONEC@iubacs           |     __
| Internet:  [e-mail]  |   /                 __
|                                    |  |      *  |\   |  |  \  \   /
| SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
|             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
**************************************   \ __  |  |   \|  |__/    |
=========================================================================
Date:         Wed, 10 Nov 1993 16:42:47 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: adding fields inside a record
In-Reply-To:  Message of Wed,
              10 Nov 1993 16:15:11 EST from <[e-mail]. EDU>

RTFM is not always enough with Access...there are some things that make
a lot of sense in dBase that left me scratching my head for weeks in
Access.

All you need to do (I think:) is take that expression and create a new
query.  Include all the fields you want in your query and add a new
"field" with your expression in it.  That <should> create a new field
when the query is run (called Expr1 if you don't give it a name) that
will hold the total for those fields.

Expr1=|Hotel¢ + |Per Diem¢ + |Transportation¢

(where | and ¢ are square brackets--doggone this stupid SNA 3270 terminal!)

or whatever your fields were should do the trick.  Then you don't carry
the total in your table, but rather, it's recalculated each time you
run the query.  You can then create a report and use the query to base
it on rather than the raw table.

Does this make sense or am I completely out of it after another day in
the trenches?  :)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Wed, 10 Nov 1993 17:30:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Reed, Robert" <[e-mail]>
Subject:      Access Video Tapes

I noticed some folks asking about video tapes.  I just received video tapes
from ...

     Keystone Learning Systems
     125 E. 300 S
     Suite 205
     Provo, UT  84606
     800-748-4838

I bought the 3 tape set ($130 I think).  It covers Beginning, Intermediate,
& Advanced topics.  I thought it was quite good.

 -=[Robert Reed, [e-mail]]=-
=========================================================================
Date:         Wed, 10 Nov 1993 18:31:22 -0500
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Margaret Redding <[e-mail]>
Subject:      Re: training materials for access...

>
>Greetings:
>
>I'm a very new user of access, and next spring I will be responsible for
>training a dozen or so new users.  Do any of you know of any supplemental
>training materials for helping us to learn access better?  In particualr, a
>videotape, or a book with exercises and accompanying disk etc.

I taught myself access using a book put out by Ziff Davis called "PC
Learning Labs teaches Microsoft Access." It has a disk, with sample
databases, forms, reports and queries, and exercises that build on the
points just taught, and points that have been taught so far in the book.
So you have exercises that require you to have mastered everything you
have covered so far--a good practice.

I enjoyed learning from this book, and certainly feel I learned a great
deal. When I created my own form with a combo-box, buttons etc. I felt
very satisfied. And what I learned has stayed with me--I don't use Access
much, but when I go into it, I find I have remembered a great deal.

Good luck


Margaret Redding





>
>We have the documentation that came with access, but as a trainer we need
>something to work into our own materials.  Any third party leads would be most
>appreciated.  Thanks
>
>Cindy Stone
>
>**************************************    Says a student, "So
>| Cindy Stone, Training Specialist   |    how many afternoons
>| Indiana University - Bloomington   |    do you think it will take
>| Department of Physical Plant       |    me to learn tabletop publishing?"
>| Bitnet:    STONEC@iubacs           |     __
>| Internet:  [e-mail]  |   /                 __
>|                                    |  |      *  |\   |  |  \  \   /
>| SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
>|             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
>**************************************   \ __  |  |   \|  |__/    |
>
>

--
Margaret Redding  [e-mail]
Ottawa, Ontario
CANADA
=========================================================================
Date:         Thu, 11 Nov 1993 08:06:06 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Gary T Ogren <[e-mail]>
Subject:      Re: training materials for access...

In message <[e-mail]> Microsoft Access Database
Discussion List
 writes:
> Greetings:
>
> I'm a very new user of access, and next spring I will be responsible for
> training a dozen or so new users.  Do any of you know of any supplemental
> training materials for helping us to learn access better?  In particualr, a
> videotape, or a book with exercises and accompanying disk etc.
>
> We have the documentation that came with access, but as a trainer we need
> something to work into our own materials.  Any third party leads would be
> most
> appreciated.  Thanks
>
> Cindy Stone
>
> **************************************    Says a student, "So
> | Cindy Stone, Training Specialist   |    how many afternoons
> | Indiana University - Bloomington   |    do you think it will take
> | Department of Physical Plant       |    me to learn tabletop publishing?"
> | Bitnet:    STONEC@iubacs           |     __
> | Internet:  [e-mail]  |   /                 __
> |                                    |  |      *  |\   |  |  \  \   /
> | SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
> |             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
> **************************************   \ __  |  |   \|  |__/    |
>

There is something called Windows Academy based in Florida.  They have a
videotape program(5 tapes for $49 each) available.  There toll free order line
is 1-800-527-1914.


Gary T. Ogren
Office of Human Resources
University of Minnesota
University Technology Ctr
Room 300
1313 5th Street S.E.
Mpls, MN, 55414
[phone]
=========================================================================
Date:         Thu, 11 Nov 1993 06:01:37 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      MS Access on a MAC?

     I am database manager in my office.  We have a group of PC's
     networked together, reading and writing to a common MS
     Access database file.

     Now, there is ONE fellow who decided he wanted a Mac (isn't
     there always one?)  He is connected to the same network, but
     can't get access to the database because I can't find
     software for him.

     Does anyone know if Microsoft is planning a Mac version of
     MS Access?  Is there another software package that will let
     him read and write to the database?  Any other suggestions
     (I've already tried telling him to get a PC, to no avail)?

     TIA,

     Thornton Prime
=========================================================================
Date:         Thu, 11 Nov 1993 11:45:43 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Troy D. Weidner" <[e-mail]>
Subject:      Re: training materials for access...
In-Reply-To:  <[e-mail]>

        ComputerPREP, inc., 410 N 44th St. Suite 600, Phoenix, Arizona 85008
Sells Courseware for many programs. I found the manual and sample files
execlent.


Troy Weidner
Dept. of Telecommunications
Kutztown University
PO Box 730  Kutztown, PA 19530-0730
Phone: [phone] Fax:   [phone]


On Wed, 10 Nov 1993, PROTECT THE RIGHT-KEEP & ARM BEARS wrote:

> Greetings:
>
> I'm a very new user of access, and next spring I will be responsible for
> training a dozen or so new users.  Do any of you know of any supplemental
> training materials for helping us to learn access better?  In particualr, a
> videotape, or a book with exercises and accompanying disk etc.
>
> We have the documentation that came with access, but as a trainer we need
> something to work into our own materials.  Any third party leads would be most
> appreciated.  Thanks
>
> Cindy Stone
>
> **************************************    Says a student, "So
> | Cindy Stone, Training Specialist   |    how many afternoons
> | Indiana University - Bloomington   |    do you think it will take
> | Department of Physical Plant       |    me to learn tabletop publishing?"
> | Bitnet:    STONEC@iubacs           |     __
> | Internet:  [e-mail]  |   /                 __
> |                                    |  |      *  |\   |  |  \  \   /
> | SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
> |             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
> **************************************   \ __  |  |   \|  |__/    |
=========================================================================
Date:         Thu, 11 Nov 1993 16:58:27 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      MS Access on a MAC?

%
%      Now, there is ONE fellow who decided he wanted a Mac (isn't
%      there always one?)  He is connected to the same network, but
%      can't get access to the database because I can't find
%      software for him.
%
%      Does anyone know if Microsoft is planning a Mac version of
%      MS Access?  Is there another software package that will let
%      him read and write to the database?  Any other suggestions
%      (I've already tried telling him to get a PC, to no avail)?

There has been talk in the public media about a FoxPro 2.5 for
the Mac.  I wonder if you could kludge something together until
a decision is made about Access/Macintosh?

phil
=========================================================================
Date:         Thu, 11 Nov 1993 17:05:09 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: MS Access on a MAC?
In-Reply-To:  Message of Thu,
              11 Nov 1993 16:58:27 EST from <72410.2162@COMPUSER VE.COM>

Or how about OBDC?  or does that not work on a MAC?

Puzzledly:),
-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 11 Nov 1993 19:39:38 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Resent-From: Nathan Brindle <NBRINDLE@INDYCMS>
From:         Nathan Brindle <[e-mail]>
Subject:      Re: NS Access on a MAC?

The  enclosed mail  file, found  in the  ACCESS-L reader  and shown  under the
spoolid 3803  in the console log,  has been identified as  a possible delivery
error notice for the following reason: "Sender:", "From:" or "Reply-To:" field
pointing to the list has been found in mail body.

>From: George Raudabaugh <[e-mail]>
>Subject: Re: MS Access on a MAC?

From Nathan:
>
> Or how about OBDC?  or does that not work on a MAC?
>
> Puzzledly:),

The ODBC SDK for the Mac has been released by Apple, its closely integrated
with DAL (Data Access Language) and DAM (Data Access Methods?).  Per the
notes, it would appear this is a link for DAL applications on the MAC to
talk to MAC/ODBC drivers (how many apps, I don't know, I would assume greater
than zero).  Also, ODBC apps on the Mac (zero at this time I would guess)
could talk to DAL databases locally on the Mac.

All of this required reading something between the lines of the release notes.
There weren't any nice pictures that explained the 1000 words.

If anyone from Apple can clarify the above (or from Microsoft), I'd love
to hear it (and probably the rest of the list).

GR
--
George Raudabaugh               Manager/Document Technologies
Information Dimensions, Inc.    [e-mail]            (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio  43017             [phone]                     (voice mail)

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Fri, 12 Nov 1993 11:50:30 GMT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Richard Saunders,
              Computer Centre" <[e-mail]>
Organization: University Of East London
Subject:      Changing object names

Is there any way to change the name of an Access database object
wherever it occurs in the database in one simple global operation?
=========================================================================
Date:         Fri, 12 Nov 1993 07:41:57 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kenneth Hutchinson <[e-mail]>
Subject:      Exclusive Function?

 Is there a function in Access Basic that determines the state of
the open database in terms of exclusivity? We have a shared database
on the network, and I want to prevent people (or at least check when)
people open the database in exclusive mode. Any thoughts and suggestions
would be appreciated. You can e-mail a response directly to me if you'd
like. Thank you.

Ken Hutchinson
[e-mail]
=========================================================================
Date:         Fri, 12 Nov 1993 06:10:18 +0000
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Marty McMahon <[e-mail]>
Subject:      RE>ACCESS Training materials

------------------------------

Cindy,  Here at Boeing we have a course on Access 1.1 that combines VHS tapes (
3) and Computer assisted instruction via a manual and samples disks.  This
course is in three parts: Tables, Queries and Forms/Reports.  Each has it's
own tape, disk and manual.  Excellant starter set.  I don't know the cost but
here is the other info.

Learn PC Inc.
10729 Bren Road East
Minneapolis MN 55343 USA
800-532-7672
612-930-0330

Hope this helps.

Marty McMcMahon
Standard disclaimer applies.

Date:    Wed, 10 Nov 1993 16:05:59 EST
From:    PROTECT THE RIGHT-KEEP & ARM BEARS <[e-mail]>
Subject: training materials for access...

Greetings:

I'm a very new user of access, and next spring I will be responsible for
training a dozen or so new users.  Do any of you know of any supplemental
training materials for helping us to learn access better?  In particualr, a
videotape, or a book with exercises and accompanying disk etc.

We have the documentation that came with access, but as a trainer we need
something to work into our own materials.  Any third party leads would be most

appreciated.  Thanks

Cindy Stone

**************************************    Says a student, "So
| Cindy Stone, Training Specialist   |    how many afternoons
| Indiana University - Bloomington   |    do you think it will take
| Department of Physical Plant       |    me to learn tabletop publishing?"
| Bitnet:    STONEC@iubacs           |     __
| Internet:  [e-mail]  |   /                 __
|                                    |  |      *  |\   |  |  \  \   /
| SNAIL Mail: 912 North Walnut Grove |  |      |  | \  |  |   |  \ /
|             Bloomington, IN  47405 |  |      |  |  \ |  |   |   |
**************************************   \ __  |  |   \|  |__/    |

------------------------------
=========================================================================
Date:         Fri, 12 Nov 1993 16:06:05 MEZ+1
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bob Koutsky <[e-mail]>
Organization: VCUK Mat.-fyz. fakulta UK, Praha
Subject:      Disabling action query messages

Hello,

does somebody know how to disable message boxes generated before an
action query is run ? "Options -> General -> Confirm Action Queries =
No" disables ony the 'Delete query will modify data...' msgbox, ' xx
records will be deleted' is generated regardless of this setting...
And "DoCmd Warnings False" seems to be active only while executing
single macro or function ...

thanx,

Bob Koutsky
Computer Centre of Charles University
Prague
Czech republic
=========================================================================
Date:         Fri, 12 Nov 1993 11:39:26 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Error codes

HI,
     Does anyone know how to get a list of all the Err values and their
meanings?  I'd like
to have a list so that I can write decent error handling routines in my AB code.

Example:   If Err = x Then  'Disk full error
                 Else If Err = y Then 'File not found

Etc.


Thanks!

John A. Olson
Computing Devices International

[e-mail]
=========================================================================
Date:         Fri, 12 Nov 1993 19:28:28 MEZ
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Erich Neuwirth <[e-mail]>
Subject:      after update property

i need some help with the after update property in a form.
i have 4 fields in a hierarchy, meaning that the value of field 1
determines the set of possible values for field 2, the value of
field 2 determines the set of possible values for field 3 and so on.
so when the value of field 1 is changed, then fields 2 to 4 should be cleared
immediately (they are set to 0 in my case).
i am doing this byu using the after update property of field 1, running a macro
which does setvalue for the controls for field 2 and so on.
the problem is that these macros alse are executed when i go to
another, already existing record. so when i change records my fields
also are set to 0.
is there a way of running the macro only when the value of an existing
record is changed, but not when i switch from one record to the next one?

ERICH NEUWIRTH
BITNET (EARN): A4422DAB@AWIUNI11
INTERNET:      [e-mail] = 131.130.1.2
Institute for Statistics, Operations Research, and Computer Methods
UNIVERSITY OF VIENNA, UNIVERSITAETSSTR. 5/9, A-1010 VIENNA, AUSTRIA
TEL.: [phone]    FAX: [phone]
=========================================================================
Date:         Fri, 12 Nov 1993 15:24:42 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Changing object names
In-Reply-To:  <[e-mail]> from "Richard Saunders,
              Computer Centre" at Nov 12, 93 11:50:30 am

>
> Is there any way to change the name of an Access database object
> wherever it occurs in the database in one simple global operation?
>
No.

Sorry.

John
[e-mail]
=========================================================================
Date:         Fri, 12 Nov 1993 15:29:32 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: NS Access on a MAC?
In-Reply-To:  <[e-mail]> from "Nathan Brindle" at Nov
              11, 93 07:39:38 pm

Just a note on Access for the Mac.  Access BASIC is written entirely in
8086 Assembler.  It will not be easy to port.  Don't hold your breath.

John
[e-mail]
=========================================================================
Date:         Fri, 12 Nov 1993 15:39:53 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Updating other fields in a record from a form.
In-Reply-To:  <[e-mail]> from "RON APLAND AH204" at Nov
              10, 93 12:10:47 pm

Ron,

I'm not sure I precisely understand your problem.  If what you are
trying to do is update a table, using data that you do not want to
appear on the screen, put the data in hidden (visible=no) fields on the
screen.  If they are bound to the underlying table, the update will take
place.

John
=========================================================================
Date:         Fri, 12 Nov 1993 15:36:34 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: adding fields inside a record
In-Reply-To:  <[e-mail]> from "PROTECT THE RIGHT-KEEP &
              ARM BEARS" at Nov 10, 93 04:15:11 pm

Cindy,

Create a derived field in the query:

TravelTotal: [Airfare] + [Meals] + [Transportation] + ...

It should do the trick.

John

[e-mail]
=========================================================================
Date:         Sat, 13 Nov 1993 22:16:07 MEZ
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Erich Neuwirth <[e-mail]>
Subject:      self updating form problem again

earlier i described a problem with using the after update property
for field  controls connected to an underlying table.
the problem was that going to anotherb record also triggered the macro
connected to this property, and this produced unwanted results.
i mamanged to solve this problem by adding a macro to the on current
property of the whole form. this macro does a refresh through the
domenuitem action. then things work as i want them to work.
now there is one more problem.
i want to show the table which the form is connected to in another
form window at the same time. this is possible. but when i change
or add records in one view, the other view based upon a query
built on top of the same table is NOT updated. is there a way to force
the query and/or table to update itself as soon as the underlying
tabke is changed?

ERICH NEUWIRTH
BITNET (EARN): A4422DAB@AWIUNI11
INTERNET:      [e-mail] = 131.130.1.2
Institute for Statistics, Operations Research, and Computer Methods
UNIVERSITY OF VIENNA, UNIVERSITAETSSTR. 5/9, A-1010 VIENNA, AUSTRIA
TEL.: [phone]    FAX: [phone]
=========================================================================
Date:         Mon, 15 Nov 1993 07:57:00 MST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Leisa Refalo <[e-mail]>
Subject:      Re: training materials for access...

DATACAL Direct has a catalog that contains training videos for Access.
They offer 2 videos from ViaGrafix.
Introduction to Access (55 minutes) for $49.95 and
Using Access (65 minutes) for $49.95

DATACAL's toll free ordering number is 1-800-251-3370 and the fax number is
1-602-545-8090.  I believe they will send a free catalog upon request.

Leisa ReFalo
=========================================================================
Date:         Mon, 15 Nov 1993 21:12:18 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kenneth Hutchinson <[e-mail]>
Subject:      Parameterized Queries

 Does anyone know how a variable can be passed from Access Basic to a
parameterized query. Instead of prompting the user with that query
dialog box, I have a form with a number of radio buttons. Each button
corresponds to a parameter that I want the query to execute on. Now,
I want to pass the button value to the parameterized query.
 Any help would be greatly appreciated.

Ken Hutchinson
[e-mail]
=========================================================================
Date:         Mon, 15 Nov 1993 18:14:15 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: self updating form problem again
In-Reply-To:  <[e-mail]> from "Erich Neuwirth" at Nov
              13, 93 10:16:07 pm

Erich,

What you need to do is Requery the form.  That will update the form with
data from the underlying query.  You can do this with either Access
BASIC or a macro.  Run the action from the on update property of the
first form.  If the first form is form1 and the second form is form2
your sequence would be:

Move focus to form2
Requery form2 (do a requery without parameters)
Move focus back to form1

John
[e-mail]
=========================================================================
Date:         Tue, 16 Nov 1993 09:43:55 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         KENTON HENSLEY 617-496-2131 <[e-mail]>
Subject:      Re: Parameterized Queries
In-Reply-To:  Your message dated "Mon,
              15 Nov 1993 21:12:18 -0500" <[e-mail]>

Have you checked out page 137 of the Access provided "Introduction
to programming"?  The first example on that page shows how to create
a QueryDef variable (parameter query variable) and how to pass a value
to the paramters you've defined.

Kenton
[e-mail]
=========================================================================
Date:         Tue, 16 Nov 1993 07:24:41 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Mark=[e-mail]
Subject:      Re: Parameterized Queries

Kenneth Hutchinson <[e-mail]> Wrote:
|  Does anyone know how a variable can be passed from Access
| Basic to a
| parameterized query. Instead of prompting the user with that
| query
| dialog box, I have a form with a number of radio buttons.
| Each button
| corresponds to a parameter that I want the query to execute
| on. Now,
| I want to pass the button value to the parameterized query.
|  Any help would be greatly appreciated.

Well, if I understand you correctly, then here's what I'd do:

On the form, once the user selects the button to run the query (I assume
this is the triggering device) then the Basic code will interpret which
button is pressed and adjust the contents of a text boxt i.e.

        select ButtonValue
                case 1
                        Forms![FormName].myBox="parameterA"
                case 2
                        Forms![FormName].myBox="parameterB"
                ...
        end select

Then on the query, where you are specifying the criteria, have that field
set to:

        Forms![FormName].myBox

Also, on the Texbox (myBox), adjust it's properties in the design view, so
that it's not visible.

Don't know if this is the BEST way, but it worked for me!  :)

Enjoy!
=========================================================================
Date:         Tue, 16 Nov 1993 18:01:38 +0100
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Edgar Greuter <[e-mail]>
Subject:      Re: How can I hide tables ? -> Solution!

Hi all!

Today i have discovered, how tables, queries, ... can be hidden from the
database window just as the "system objects".

        1) select "options" - "hide system objects" - "no"
        2) in table MsysObjects locate your table (identified by the name)
        3) change the flags field to a value <> Null and <> 0
        4) select "options" - "hide system objects" - "yes"

That`s all. All queries based on those tables still work.

        - Edgar
=========================================================================
Date:         Tue, 16 Nov 1993 09:09:10 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      Re: Parameterized Queries
In-Reply-To:  <[e-mail]>; from "Kenneth Hutchinson"
              at Nov 15, 93 9:12 pm

>
>  Does anyone know how a variable can be passed from Access Basic to a
> parameterized query. Instead of prompting the user with that query
> dialog box, I have a form with a number of radio buttons. Each button
> corresponds to a parameter that I want the query to execute on. Now,
> I want to pass the button value to the parameterized query.
>  Any help would be greatly appreciated.
>

If you are passing all the parameters, the easiest
is to just put them right into the query.

In the criteria section for the field in a query, put:

forms!FormName!FieldName

If its a subform, try:

forms!FormName!SubForm.form!FieldName

where Subform is the control name of the subform.


If only some of the parameters are to be passed,
I create an Expr column such as x

x:iif(isnull(forms!formname!fieldname) or
QueryField=forms!formname!fieldname,1,0)

and put 1 in the criteria for the query.

Thats assuming a blank parameter is null.
=========================================================================
Date:         Tue, 16 Nov 1993 15:49:24 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         "Brian Keeler (403) - 471-8623" <[e-mail]>
Subject:      ACCESS DB problem

We have a .MDB file that contains 23,000 records.
A number of calculations on done on several fields,
and it is running on a Novell network 3.11.
With out SHARE.EXE in the AUTOEXEC.BAT file installed
the job takes 3 min 43 seconds on a 486/66 mhz PC clone.
With SHARE.EXE installed on the same machine, same
network, the job was cancelled after 1 hour 30 minutes
and it had only processed 900 records. SHARE had the
parameter /L:500 in the autoexec.bat file. We were under
the impression that this parameter stops different users
from accessing the same fields/records in the database.

Does anyone know or understand why this would happen??
Has anyone else had this same problem occur to them??
Are we wrong in our impression of SHARE??

Brian Keeler (403) - 471-8623     ..What is a CD-ROM ??
Application Services Coordinator   3 billion pits arranged
Information Services Division      in a 3 mile spiral...
domain: [e-mail]
=========================================================================
Date:         Wed, 17 Nov 1993 07:59:39 PST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: ACCESS DB problem
In-Reply-To:  <[e-mail]>; from "Brian Keeler" at Nov
              16, 93 3:49 pm

> We have a .MDB file that contains 23,000 records.
> A number of calculations on done on several fields,
> and it is running on a Novell network 3.11.
> With out SHARE.EXE in the AUTOEXEC.BAT file installed
> the job takes 3 min 43 seconds on a 486/66 mhz PC clone.
> With SHARE.EXE installed on the same machine, same
> network, the job was cancelled after 1 hour 30 minutes
> and it had only processed 900 records. SHARE had the
> parameter /L:500 in the autoexec.bat file. We were under
> the impression that this parameter stops different users
> from accessing the same fields/records in the database.
>
> Does anyone know or understand why this would happen??
> Has anyone else had this same problem occur to them??
> Are we wrong in our impression of SHARE??

Well, SHARE is only used on your local workstation. In Access,
when you are working on a .MDB file on the network, Access utilizes
the network's own record-locking scheme to manage record locking,
so SHARE isn't supposed to come into play. It sounds to me like,
for some reason, Access is still using SHARE to manage record
locking over your Novell network. I don't know Novell, I only
know Banyan. On Banyan, record locking is managed by the network.

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
----Software Technician       |
=========================================================================
Date:         Wed, 17 Nov 1993 13:38:17 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: ACCESS DB problem

From: "Tony Hamilton - FES ERG~" <[e-mail]>
% Well, SHARE is only used on your local workstation. In Access,
% when you are working on a .MDB file on the network, Access utilizes
% the network's own record-locking scheme to manage record locking,
% so SHARE isn't supposed to come into play. It sounds to me like,
% for some reason, Access is still using SHARE to manage record
% locking over your Novell network. I don't know Novell, I only
% know Banyan. On Banyan, record locking is managed by the network.

I can't speak to all of the locking since I haven't tinkered in
awhile [and have been breaking various forthcoming software products
for books ;) ] -- I *do* know, however, that Access & Novell don't get
along real well when it comes to speed.  No functional problems,
but I know through keeping my ear to the ground that many people
running Access across networks are very, very reluctant to do so
on Novell flavours.

---------------------------------------------------------------------
phil paxton
development editor
sams/prentice hall computer publishing  <=== "GO SAMS" via Compuserve
paramount publishing
indianapolis, indiana
317.581.3756
=========================================================================
Date:         Wed, 17 Nov 1993 16:19:38 MDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Converted from PROFS to RFC822 format by PUMP V2.1
From:         Jack Wiercinski <[e-mail]>
Subject:      Access - Out Of Memory

I have Access 1.1 database 650 000 records (55 MB). Until recently when size
of database was approx 40 MB I was able to compact it (using Access
1.0).Presently I am using Access 1.1 and Format is 1.1.

Now, whenever I try to compact my database I am getting "Out of Memory"
message.

 I have 32MB RAM and 240MB free disk space on 486 50MHz PC.I created a huge
120MB permanent swapfile, I defragmented my disk,I removed my PC from the
network, removed all TSR, to no avail. I am very concerned that I can't
compact my database. The application which I am running is crucial to my
organization. Any ideas?

Jack                                    ISD NAIT [phone]
=========================================================================
Date:         Thu, 18 Nov 1993 07:41:06 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Richard Moldwin <[e-mail]>
Subject:      Re: Access - Out Of Memory
In-Reply-To:  Your message of Wed, 17 Nov 1993 16:19:38 MDT

Jack, did you try to repair the database before compacting? Maybe that will
 work.
=========================================================================
Date:         Thu, 18 Nov 1993 06:39:44 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Parameterized Queries
In-Reply-To:  <[e-mail]> from "[e-mail]" at Nov 16,
              93 09:09:10 am

To pass parameters to a query do the following

Dim QD as QueryDef
Dim DB as Database
Dim DS as Dynaset

Set DB = CurrentDB()
Set QD = DB.OpenQueryDef("TestQuery")

QD("Forms!Form1!Field1") = Forms!Form1!Field1
Set DS = QD.CreateDynaset()

This works, and it's fast and easy.

John
[e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 06:43:24 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: How can I hide tables ? -> Solution!
In-Reply-To:  <[e-mail]> from "Edgar Greuter" at Nov 16,
              93 06:01:38 pm

Edgar,

I would STRONGLY advise against using this technique.  If future
versions of Access do not have the ability to modify the system tables,
you will have serious problems.  Objects hidden using version 1.1
_might_ not be recoverable to visible status using future versions of
Access.

John
[e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 10:19:59 EDT
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Dave Finley <[e-mail]>
Subject:      Access Versus PowerBuilder

For an upcoming project, my company is trying to decide between PowerBuilder
and Access. From what I can determine, the main difference is price per
package (list price of $495 for Access versus almost $3000 for PowerBuilder).
But I would like to hear from others, especially Access users who've also used
PowerBuilder. Is PowerBuilder better than Access? Enough so to justify the
price difference?


Dave Finley
[e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 07:05:21 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access - Out Of Memory
In-Reply-To:  <[e-mail]> from "Jack Wiercinski" at Nov
              17, 93 04:19:38 pm

Jack,

I think I know what the problem is.  When Access compacts a database, it
creates a copy of your MDB to work from.  Therefor, if you don't have 55
MB of free _disk_ space you are getting an Out of Memory message.
Creating a huge swap file may have made the problem worse.

Please give this a try, and get back to me if you continue to have
problems.

John
[e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 09:17:42 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kevin Muenzler <[e-mail]>
Organization: University of Texas Health Science Center at San Antonio
Subject:      Re: Access - Out Of Memory

>I have Access 1.1 database 650 000 records (55 MB). Until recently when size
>of database was approx 40 MB I was able to compact it (using Access
>1.0).Presently I am using Access 1.1 and Format is 1.1.
>
>Now, whenever I try to compact my database I am getting "Out of Memory"
>message.

> I have 32MB RAM and 240MB free disk space on 486 50MHz PC.I created a huge
>120MB permanent swapfile, I defragmented my disk,I removed my PC from the
>network, removed all TSR, to no avail. I am very concerned that I can't
>compact my database. The application which I am running is crucial to my
>organization. Any ideas?

>Jack                                    ISD NAIT [phone]


Jack,
        I have the same problem with a 570K record database.  I was trying
to key the database and set ref integrety checks.  I got "Out of Memory" also.
My machine is a 486DX-33 with 8MB memory and a 32MB swap file.  I crashes
at about 5% finished.

                        Kevin
[e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 08:10:11 PST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Tony Hamilton - FES ERG~" <[e-mail]>
Subject:      Re: Access - Out Of Memory
In-Reply-To:  <[e-mail]>; from "Jack Wiercinski" at
              Nov 17, 93 4:19 pm

> I have Access 1.1 database 650 000 records (55 MB). Until recently when size
> of database was approx 40 MB I was able to compact it (using Access
> 1.0).Presently I am using Access 1.1 and Format is 1.1.
>
> Now, whenever I try to compact my database I am getting "Out of Memory"
> message.
>
>  I have 32MB RAM and 240MB free disk space on 486 50MHz PC.I created a huge
> 120MB permanent swapfile, I defragmented my disk,I removed my PC from the
> network, removed all TSR, to no avail. I am very concerned that I can't
> compact my database. The application which I am running is crucial to my
> organization. Any ideas?

Just one, Jack. Call Microsoft. They'll surely be able to tell you if you've
hit some little-known limit or something. Then, when you find out, please
let the rest of us know... :-)

--
Tony Hamilton                 |
-Intel Corporation            | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: [e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 11:34:38 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: Access - Out Of Memory
In-Reply-To:  Message of Thu,
              18 Nov 1993 08:10:11 PST from <[e-mail] EL.COM>

On Thu, 18 Nov 1993 08:10:11 PST Tony Hamilton - FES ERG~ said:
>
>Just one, Jack. Call Microsoft. They'll surely be able to tell you if you've
>hit some little-known limit or something. Then, when you find out, please
>let the rest of us know... :-)
>

Begin(Flame) <not aimed at you, Tony!>
Or (gee!) the two Microsoft subscribers to this group could comment from
time to time also...I'm beginning to wonder why they're here.  It's kind
of irritating to me that on VISBAS-L, Microsoft people comment all the
time about problems that people are having, but we almost never get any
input here on ACCESS-L.  I've offered this group as a support forum,
"user group", or what have you, and the answer I got from MS was "but
aren't most of the people on the list academic users?"  I pointed out
(and followed up with a letter) that MANY of the subscribers are NOT
at academic nodes.  Plus--what difference would it make if they were?
I have heard nothing since.

I wasn't going to get into this but it's been bugging me for months.
I guess if you want to pay for Compu$erve, you can get Access support
on line.
End(Flame)

I'm not putting this up for discussion, BTW--I'm just venting my spleen
as a list owner.  We now return to our regularly-scheduled program....

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Thu, 18 Nov 1993 12:05:16 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Access - Out Of Memory

% I have Access 1.1 database 650 000 records (55 MB). Until recently when
% size of database was approx 40 MB I was able to compact it (using Access
% 1.0).Presently I am using Access 1.1 and Format is 1.1.

% Now, whenever I try to compact my database I am getting "Out of Memory"
% message.

% I have 32MB RAM and 240MB free disk space on 486 50MHz PC.I created a huge
% 120MB permanent swapfile, I defragmented my disk,I removed my PC from the
% network, removed all TSR, to no avail. I am very concerned that I can't
% compact my database. The application which I am running is crucial to my
% organization. Any ideas?

I know the MS people watch this forum but seem to only lurk.  I'd suggest
you upload this to Compu$erve since there is such a large Access
following there, both in the developer and MS communities.

phil
=========================================================================
Date:         Thu, 18 Nov 1993 16:24:20 CST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Crookall <[e-mail]>
Organization: Simulation & Gaming - Project IDEALS
Subject:      Re: Access - Out Of Memory
In-Reply-To:  Message of Thu, 18 Nov 1993 11:34:38 EST from <NBRINDLE@INDYCMS>

Well said, Nathan.
(David Crookall)
=========================================================================
Date:         Thu, 18 Nov 1993 15:22:49 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Versus PowerBuilder
In-Reply-To:  <[e-mail]> from "Dave Finley" at Nov 18,
              93 10:19:59 am

Dave,

If your users only need an executable version of your application, get
the Access Distribution Kit.  It's $495, and you can find it for $300.
It distributes a runtime version of the application, with now royalties.
My experience with it has been positive.

John
[e-mail]
=========================================================================
Date:         Thu, 18 Nov 1993 20:15:58 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         SAM SCHMITT <[e-mail]>
Subject:      Re: Access Versus PowerBuilder

I've had some limited experience with both products in project situations.
Powerbuilder is a much more powerful tool, but it is way over priced for
the maturity of the product.  My former organization spent many hours
working around the product's bugs which caused significant delays in the
project.  As for Access, it's a little like comparing apples and oranges.
Access is also very immature, but from what I gather is now stable in
version 1.1.  It's not the same caliber tool as Powerbuilder but it's much
less expensive and somewhat easier to master.  I'm not sure what you're
wanting to do exactly but you might want to consider using Visual Basic 3.0
with ODBC to a SQL Server back end.  Visual Basic is essentially the same
language as Access but you have the third party add ins and can compile to
.EXE code.  It also comes with what appears to be Access's database engine
if you purchase the Professional Edition.  If you are looking for an easy
to work with database development language that can compile .EXE's and still
do some sophisticated programming without getting involved with C++, Visual
Basic is worth exploring.

I personally would steer away from PowerBuilder, the price/performace isn't
there and PowerBuilder is an expensive product to learn.

Best Wishes
--Sam
=========================================================================
Date:         Fri, 19 Nov 1993 12:22:17 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
Comments:     Resent-From: Nathan Brindle <NBRINDLE@INDYCMS>
From:         Nathan Brindle <[e-mail]>
Subject:      Microsoft's Participation

The  enclosed mail  file, found  in the  ACCESS-L reader  and shown  under the
spoolid 1407  in the console log,  has been identified as  a possible delivery
error notice for the following reason: "Sender:", "From:" or "Reply-To:" field
pointing to the list has been found in mail body.

------------------------- Message in error (71 lines) -------------------------
>Date:         Fri, 19 Nov 93  12:08:18 EST
>From:         Michael Blankenstein <U7530MB@DOEVM>
>Subject:      Microsoft's Participation
>In-Reply-To:  note of 11/18/93 13:40
>To:           <ACCESS-L@INDYCMS>


I am not an "academic user"! But what's that got to do with Microsoft's
participation with this particular forum.

Michael Blankenstein
Computer Systems Manager
U.S. Dept of Energy

[e-mail]

On Thu, 18 Nov 1993 08:10:11 PST Tony Hamilton - FES ERG~ said:
>
>Just one, Jack. Call Microsoft. They'll surely be able to tell you if you've
>hit some little-known limit or something. Then, when you find out, please
>let the rest of us know... :-)
>

Begin(Flame) <not aimed at you, Tony!>
Or (gee!) the two Microsoft subscribers to this group could comment from
time to time also...I'm beginning to wonder why they're here.  It's kind
of irritating to me that on VISBAS-L, Microsoft people comment all the
time about problems that people are having, but we almost never get any
input here on ACCESS-L.  I've offered this group as a support forum,
"user group", or what have you, and the answer I got from MS was "but
aren't most of the people on the list academic users?"  I pointed out
(and followed up with a letter) that MANY of the subscribers are NOT
at academic nodes.  Plus--what difference would it make if they were?
I have heard nothing since.

I wasn't going to get into this but it's been bugging me for months.
I guess if you want to pay for Compu$erve, you can get Access support
on line.
End(Flame)

I'm not putting this up for discussion, BTW--I'm just venting my spleen
as a list owner.  We now return to our regularly-scheduled program....

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Sat, 20 Nov 1993 09:59:49 AST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Howard Harawitz <[e-mail]>
Subject:      Re: ACCESS-L Digest - 18 Nov 1993 to 19 Nov 1993

Hi --

With reference to comments about Microsoft's participation, or lack of it,
in this list--specifically, the reference to most participants being
"academics", I would like to point out that while I teach at a community
college I am also an active consultant engaged in database development for
the Windows environment.

My link to the Internet has nothing to do with the school I work for. I
subscribe, personally, through a local service provider here in Nova Scotia.
Part of the reason I subscribed was to get the kind of communication and
support that a forum like this provides for professionals -- hopefully,
with the full support of major vendors like Microsoft.

While I'm at it, I would like to thank the participants and Mr. Brindle,
administrator of the list, for providing this service.

Howard
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Howard Harawitz
Nova Scotia Institute of Technology  [ [phone] ]
Halifax, Nova Scotia
Canada
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
=========================================================================
Date:         Sat, 20 Nov 1993 06:50:11 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Error codes
In-Reply-To:  <[e-mail]> from "John A. Olson" at Nov 12,
              93 11:39:26 am

Jack,

The following Access BASIC code will list the error codes for you.  It
is from the Access Basic Cookbook by Chris St. Valentine.  It creates a
text file of the error codes.  You just need to modify it to create a
table.

John

Function UsedErrors() as Integer

     Dim FileNumber as Integer, T as String, X as Long

     T = Chr$(9)
     X = O
     FileNumber = FreeFile
     On Error Resume Next
     Open"ERRORS.TXT" For Output As FileNumber
     If Err Then
          UsedErrors = False
     Else
          Do While True
                X = X + 1
                If Left(Error(X), 18) <> "User-defined error" then
                     If Err Then
                          Exit Do
                     Endif
                     Print #FileNumber, X; T; Error(X)
                Endif
          Loop
          Close FileNumber
          UsedErrors = True
     End If
     On Error GoTo 0
End Function
=========================================================================
Date:         Sat, 20 Nov 1993 23:25:48 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         GF05933 <[e-mail]>

topic: help
=========================================================================
Date:         Sun, 21 Nov 1993 20:59:02 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: training materials for access...

Small world.  I have the same goal for our campus next semester.  We are
currently trying to order the training materials from MS.  They have the
student guides, but are still developing the instructor material.  None the
less, we have on order what we can get.

One text book I've found to be helpful fro training is "MicroSoft Access For
Windows, Step by Step."  It is by MS press and has exercises and a
guess-tiamte on how long each exercise takes.  From what I can tell it is
pretty good stuff.

------------------------------------------------------
Bill Stewart
[e-mail]
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date:         Sun, 21 Nov 1993 21:08:39 -0700
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Bill Stewart <[e-mail]>
Subject:      Re: Access - Out Of Memory

I had the same problem with compacting a database.  My fix was to use
visual basic to write a short program to perform the compacting.  My guess
is that the out of memory error is really an error that not enough
resources are available.

It's my understanding that you can have gigabytes of RAM and still run out
of memory.  What happens is, windows only has 640K(best guess) of resources
to allocate to an application.  I've read about this a few times and really
don't want to muddy the issue by trying to explain it.  All I know is that
when MS set out to design NT, they decided not to incorporate this resource
limitation. In NT you can use as many resources as you have RAM.

I hope this helps.
=========================================================================
Date:         Mon, 22 Nov 1993 10:10:25 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      New Access Release

My apologies for the deception.

Pet peeve time:

I've deleted the offending message body (to protect the
guilty) but here was the subject:


--->   RE:      Re: ACCESS-L Digest - 18 Nov 1993 to 19 Nov 1993

For those of you who receive a digest version of the messages,
please, please, please change the subject to match the topic --
then we don't have to read through every message just because
someone doesn't keep the thread correct.  Did you feel let down
because the subject didn't match on this message?  Now you
know how the rest of us feel.  This is an Internet sin which
ranks right up there with overquoting.

Thank-you.
=========================================================================
Date:         Mon, 22 Nov 1993 09:16:57 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      MS Access Knowledge Base

     A week or two ago, there was a lot of discussion about the
     latest KB available aparently on Compuserve.  Since I don't
     have Compuserve access, I had asked if someone would mind
     uploading it to a publicly accessible FTP site.  I suggested
     FTP.CICA.INDIANA.EDU since they have a small, but growing
     Access collection of shareware and freeware.

     I still haven't seen anything new that looks like a KB file.
     Could someone upload it, or at least repost the names of the
     files so that I can go Achie'ing for them.  I understand
     that there's two separate files: the KB and a new search
     index.

     Thanks a lot.  Your help is sincerly appreciated.

     T. Prime
=========================================================================
Date:         Mon, 22 Nov 1993 12:20:08 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: MS Access Knowledge Base
In-Reply-To:  Message of Mon,
              22 Nov 1993 09:16:57 PST from <Thorton_~Prime_at_l
              [e-mail]>

The problem with putting the KB up on CICA is that it's over 1.5 megs
now.  <I> can't put it up there without a lot of trouble.  My route <has>
been download from C$erve, put on a floppy, go to the cluster, and ftp it
up to CICA.  Even at 9600 baud, it's going to take me a half-hour to down-
load it, and it won't fit on a 1.44MB floppy.  And there's no <way> I'm
going to download it at home and then use Kermit at 2400 baud to upload
it to my mainframe account (I'd be online for hours...).

Someone mentioned that all the relevant documents were on ftp.microsoft.com,
but not in the Help file format.  I seem to recall commenting that it would
sure be nice if good ol' MS would see fit to make it available that way for
ftp...

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Nov 1993 12:25:56 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Finally upgraded to 1.1

Following what I believe was a good comment from Phil, I am herewith
posting my next comment under a new Subject line.  :)

I just found the 1.1 upgrade at Best Buy (one of the local discount
places) and bought it.  Not sure what I'm supposed to be applauding,
but at least I now feel like I'm on the cutting edge...:)

I <knew> if I waited long enough it would cost me less than mailing off
to Microsoft for it....

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Nov 1993 09:37:30 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jim Richardson <[e-mail]>
Subject:      Subscriptions

Text item: Text_1

HELP

I deleted the help file for this list, and I need to log off of it.  I will be
going away for the month, and don't want mail piling up.  If some one could
please send me the help file, or, the log off command, I would appreciate it.

Thanks
=========================================================================
Date:         Mon, 22 Nov 1993 12:03:13 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jenny Jacobson <[e-mail]>
Subject:      Re: Finally upgraded to 1.1

Nathan Brindle mentioned buying the Access 1.1 upgrade.  We found the
upgrade for $14.99 from CompUSA in a Bulk Rate flyer.  We had just
to call our local store and be placed on a waiting list (4-6 weeks).
Other option would be to call 1-800-compusa.

Oh, it's #591274 in the catalog.

Jenny Jacobson
[e-mail]
=========================================================================
Date:         Mon, 22 Nov 1993 13:33:54 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Re: MS Access Knowledge Base

% The problem with putting the KB up on CICA is that it's over 1.5 megs
% now.  <I> can't put it up there without a lot of trouble.  My route <has>
% been download from C$erve, put on a floppy, go to the cluster, and ftp it
% up to CICA.  Even at 9600 baud, it's going to take me a half-hour to down-
% load it, and it won't fit on a 1.44MB floppy.  And there's no <way> I'm
% going to download it at home and then use Kermit at 2400 baud to upload
% it to my mainframe account (I'd be online for hours...).

Actually, there are two versions listed on Compu$erve -- the larger
of the two is 1.5, the other just over a Mg.  The way I ported it
home was to use PKZIP, but use the span diskette option which takes
care of the "too big" problem.

phil
=========================================================================
Date:         Mon, 22 Nov 1993 13:50:58 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      Re: MS Access Knowledge Base
In-Reply-To:  Message of Mon,
              22 Nov 1993 13:33:54 EST from <72410.2162@COMPUSER VE.COM>

Right...but it isn't two versions...it's the KB plus a big file that
allegedly allows keyword searches on the KB.  So you actually need both
to get the full benefit.

It's still too big for me to mess with.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Nov 1993 13:56:46 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Nathan Brindle <[e-mail]>
Organization: IUPUI Student Activities Office [phone]
Subject:      VERY LONG KB FILE SOMEONE MAILED TO ME

Thanks, whoever it was, but you just about lunched my account with the
very long posting . . . and I have an administrative account.  (Meaning
it's pretty big on disk space)  Please don't send files like that, I'll
find another way to get my hands on it.  Thanks.

-----------------------------------------------------BITNET:  NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS, APOSEC52, ACCESS-L, and BRTHPRNT@INDYCMS
Internet:    [e-mail]
Disclaimer:  My opinions are my own.  Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date:         Mon, 22 Nov 1993 13:29:51 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: New Access Release

>My apologies for the deception.
>
>Pet peeve time:
>
>I've deleted the offending message body (to protect the
>guilty) but here was the subject:
>
>
>--->   RE:      Re: ACCESS-L Digest - 18 Nov 1993 to 19 Nov 1993
>
>For those of you who receive a digest version of the messages,
>please, please, please change the subject to match the topic --
>then we don't have to read through every message just because
>someone doesn't keep the thread correct.  Did you feel let down
>because the subject didn't match on this message?  Now you
>know how the rest of us feel.  This is an Internet sin which
>ranks right up there with overquoting.
>
>Thank-you.
>

Now Phil,
  Are we flaming at the mouth? :)  That was a nasty trick on the rest of us.
 I thought MS was
coming out with a new version!  thanks for nothing! :)

John
=========================================================================
Date:         Mon, 22 Nov 1993 16:44:38 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Phil Paxton <[e-mail]>
Subject:      Subject Line / Was Re: New Access Release

% Now Phil,
%  Are we flaming at the mouth? :)  That was a nasty trick on the rest of us.

But it worked, didn't it?  :)  Besides:
1) it demonstrated the point, only to a stronger degree
2) would anyone have read it if it said "appropriate subject lines" ??

%  I thought MS was coming out with a new version!  thanks for nothing! :)

According to some of the trade rags, MS is.  But Microsoft & those on
NDA are not able to confirm/deny the existence or schedule of
(apparent) forthcoming products. :(

phil
=========================================================================
Date:         Mon, 22 Nov 1993 12:48:04 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Thornton Prime <"Thorton_~Prime_at_lmu-acad1"@LMUMAIL.LMU.EDU>
Subject:      Re: MS Access Knowledge Base

     Hmmmm...

     When I asked that someone put the KB files at a FTP site, I
     hadn't realized that they were so hugeomongoenormous.  It
     would be nice if Microsoft would post it at
     ftp.microsoft.com (hey, any MS people out there?), but that
     doesn't look like it will happen for a while.

     My problem is that I'm installing a database for some
     people, and would like to give them the latest Access KB.
     Unlike the other person who posted on this list, it will not
     much my account to get mail this big.

     If it is easier than FTPing it, would someone mind mailing
     it directly to me?  If you can drop me a note directly and
     wait for my response so I can clear out some old mail out of
     my folders so I can catch the KB and the keyword search
     index files.

     Thanks

     Thornton Prime
=========================================================================
Date:         Mon, 22 Nov 1993 14:21:23 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      A couple of questions...
In-Reply-To:  <[e-mail]>; from "Bill Stewart"
              at Nov 21, 93 8:59 pm

Well, here's the specific case:  I have a data-entry form, and for the date
field, I want it to default to the date entered for the previous record.
How do I do this?  Is this something I put in the table (like a Default Value)
or a macro?

Second, say I have a table with a bunch of time values in it like this (this
is for times people sign in and out of my computer lab.  I want to get
a measure of the number of users per hour):

TimeIN          TimeOut
14:00           14:05
14:02           16:23
14:25           17:01
...

I want to make a histogram from the resulting numbers...
Is there an easy way to do this, or do I have to do it programatically (like
I did in Excel...SLOW!)?

Thanks for the help.

Oh...to the Microsoft Access team:  Thanks for a totally cool program!

-Corey Lawson
[e-mail]
=========================================================================
Date:         Mon, 22 Nov 1993 14:17:30 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: MS Access Knowledge Base
In-Reply-To:  <[e-mail]> from "Nathan Brindle" at Nov
              22, 93 01:50:58 pm

I will attempt to clarify what the two files that make up the Knowledge
Base are.  The "small" file is ACC-KB.ZIP.  It is the Knowledge Base
itself.  It unzips to about 1.5 MB.  The second file is ACC-IN.ZIP.  It
is about 1.5 MB, and unzips to about 2.4 MB.  It allows you to search
the entire KB for individual words/phrases, alone or in combination.
ACC-KB.ZIP functions quite well without ACC-IN.ZIP.

I have both files, downloaded from Compuserve.  Nathan, if you can give
me a mailing (US Postal Service) I will backup the ZIP's to floppy's and
mail them to you.

John
[e-mail]
=========================================================================
Date:         Mon, 22 Nov 1993 17:20:53 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: A couple of questions...
In-Reply-To:  <[e-mail]> from "Corey Lawson" at Nov 22,
              93 02:21:23 pm

Corey,

In response to your first question. Create a new form.  Put a field on
it to hold the last date value.  Set the visible property of the form to
No.  Load your hidden form before you load your data entry form.  In the
OnUpdate property of your date field, put a function to copy the date
field to the hidden form date field (Forms![HiddenForm]![DateField] =
Forms![DataEntryForm]![DataDate]).  In the OnEnter property on the date
field on the data entry form copy the date back from the hidden form

If IsNull([DataDate]) then
    Forms![DataEntryForm]![DataDate] = Forms![HiddenForm]![DateField]
Endif

This should make it work for you.  (You may have to use
Forms![DataEntryForm]![DataDate] in the IsNull clause).

On your second question, I don't know.

Good luck.

John
[e-mail]
Woodinville, WA
=========================================================================
Date:         Tue, 23 Nov 1993 10:21:25 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Access Basic Cookbook

I received mail from John von Colditz regarding my request for a routine to
determine what all the error code definitions were, and he sent me a routine
which worked quite well.  He said it was from a book entitled "Access Basic
Cookbook" written by Chris St. Valentine.  I would like to know more about
this book.  Where can I get one?  How much does it cost?  How good IS it?  I
would have written directly to John, but I felt this might be of interest to
others as well.

By the way Nathan, if you are reading this, I seem to be getting double
messages from John von Colditz.  Any idea why?  His mail is the only mail I
seem to get duplicates from.

Cheers!

John A. Olson
[e-mail]
Computing Devices International (F.K.A. Control Data Corp.)
Bloomington, MN
=========================================================================
Date:         Tue, 23 Nov 1993 11:21:41 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         [e-mail]
Subject:      OLE links to Non-Windows applications

Fellow Access-ors,

Greetings.  Have any of you tried to establish OLE links to non-Windows
applications, such as Word Perfect for DOS or PC-ATLAS?  If so, were you
successful, and did you have to use and special tricks?

I've done some tests, but so far they haven't worked.

Any input will be greatly appreciated.

Thanks in advance.

Richard J. Pugh
----------------------------------------------------------------------------
Richard J. Pugh, Assistant Librarian      |"Traveling Eternity Road,
  110 Olin Library, Central Tech Services | What will you find there?
  Cornell University, Ithaca, NY 14853    | Carrying your heavy load,
  Internet:  [e-mail]             | Searching to find, some peace
  Phone: [phone]                   |    of mind."  --The Moody Blues
----------------------------------------------------------------------------
=========================================================================
Date:         Tue, 23 Nov 1993 09:37:32 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Malaspina News Gateway <[e-mail]>
Subject:      Re: A couple of questions...

From: [e-mail] (Ron)

In article <[e-mail]>, Corey Lawson <[e-mail]>
 writes:
> Well, here's the specific case:  I have a data-entry form, and for the date
> field, I want it to default to the date entered for the previous record.
> How do I do this?  Is this something I put in the table (like a Default Value)
> or a macro?

Use a macro; lets call it DUPFIELD.  Assign the macro to the On Enter control of
your field textbox.  In DUPFIELD select SendKeys as your action and enter
^(') as your keystrokes.  That should do it.

> Second, say I have a table with a bunch of time values in it like this (this
> is for times people sign in and out of my computer lab.  I want to get
> a measure of the number of users per hour):
>
> TimeIN          TimeOut
> 14:00           14:05
> 14:02           16:23
> 14:25           17:01
> ...
>
> I want to make a histogram from the resulting numbers...
> Is there an easy way to do this, or do I have to do it programatically (like
> I did in Excel...SLOW!)?

Don't you wish that people who write databases and spreadsheets would think
about histograms.  There are so many applications for them and yet they seem
to be missing from charting programs associated with databases, spreadsheets,
integrated programs, and now word processors.  I think we had to wait for
Excel 3 before we saw built-in histograms there.

For your specific problem, the best I can come up with is a crosstab but then
you also probably want to group your times into hours before counting frequency.
The other option, of course, is to export the data into Excel (since it sounds
like you have it) and have Excel calculate the histogram for you.

Ron
--------------------------------------------------------------------------------
Received: by mala.bc.ca (MX V3.3 VAX) id 31703; Tue, 23 Nov 1993 09:20:35 PST
To: [e-mail]
=========================================================================
Date:         Tue, 23 Nov 1993 13:19:58 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      Re: A couple of questions...

>From: [e-mail] (Ron)
>
>In article <[e-mail]>, Corey Lawson <[e-mail]>
> writes:
>> Well, here's the specific case:  I have a data-entry form, and for the date
>> field, I want it to default to the date entered for the previous record.
>> How do I do this?  Is this something I put in the table (like a Default
Value)
>> or a macro?
>
>Use a macro; lets call it DUPFIELD.  Assign the macro to the On Enter
control of
>your field textbox.  In DUPFIELD select SendKeys as your action and enter
>^(') as your keystrokes.  That should do it.
>
>> Second, say I have a table with a bunch of time values in it like this (this
>> is for times people sign in and out of my computer lab.  I want to get
>> a measure of the number of users per hour):
>>
>> TimeIN          TimeOut
>> 14:00           14:05
>> 14:02           16:23
>> 14:25           17:01
>> ...
>>
>> I want to make a histogram from the resulting numbers...
>> Is there an easy way to do this, or do I have to do it programatically (like
>> I did in Excel...SLOW!)?
>
>Don't you wish that people who write databases and spreadsheets would think
>about histograms.  There are so many applications for them and yet they seem
>to be missing from charting programs associated with databases, spreadsheets,
>integrated programs, and now word processors.  I think we had to wait for
>Excel 3 before we saw built-in histograms there.
>
>For your specific problem, the best I can come up with is a crosstab but then
>you also probably want to group your times into hours before counting
frequency.
>The other option, of course, is to export the data into Excel (since it sounds
>like you have it) and have Excel calculate the histogram for you.
>
>Ron
>---------------------------------------------------------------------------
-----
>Received: by mala.bc.ca (MX V3.3 VAX) id 31703; Tue, 23 Nov 1993 09:20:35 PST
>To: [e-mail]
>
>
Maybe I'm not understanding you correctly, but isn't there a graphing option
built into Access?  it seems to me that I have created a report which
included a graph based on data in my table.  the toolbox has an icon for
creating a graph.  how about trying that?  Just a thought.

John A. Olson
Computing Devices International
=========================================================================
Date:         Tue, 23 Nov 1993 12:46:34 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      MS-Graph question...
In-Reply-To:  <[e-mail]>; from "John A.
              Olson" at Nov 23, 93 1:19 pm

Say I have a table like this:

DayOfWeek       UsersPerDay
Sunday          1.1
Monday          2.5
Tuesday         3.1
Wednesday       5.9
Thursday        4.5
Friday          0.9
Saturday        3.1

and I want to make a bar graph of it.  When I do this, it ends up in Graph
with the DayOfWeek column alphabetized!  I can't get it (MS-Graph) to not
do this, i.e., I go in and change the rows by hand, and when I print it out
the bars still print out in alphabetical order (Fri, Mon, etc.).  So, either
Graph is doing it or Access is telling Graph to do it.  Kind of a problem,
in my opinion.

PS:  Thanks to all who replied to my prev. two questions!  The answers help
a great deal!

-Corey Lawson
[e-mail]
=========================================================================
Date:         Tue, 23 Nov 1993 12:57:35 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: MS-Graph question...
In-Reply-To:  <[e-mail]> from "Corey Lawson" at Nov 23,
              93 12:46:34 pm

Corey,

When the graph wizard creates the graph, it places an SQL statement in
the RowSource property of the graph.  I suspect there is an OrderBy
clause in there.  Pull up the form/report the graph is on in design
view.  Select the graph and look at the properties window.  Go to the
row source and press shift-F2, to bring up the zoom window.  You can
edit the SQL, save it, and your graph should work.

John
=========================================================================
Date:         Tue, 23 Nov 1993 13:06:20 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Access Basic Cookbook
In-Reply-To:  <[e-mail]> from "John A. Olson" at Nov 23,
              93 10:21:25 am

Access BASIC Cookbook
Chris St. Valentine
Addison Wesley
ISBN 0-201-62636-5
$34.95 - includes a disk

This is, as it says, a cookbook.  It has lots of techniques for doing
specific tasks in Access BASIC.  I have only had the book a short time,
but I have found it to be a wonderful reference.

John
[e-mail]
=========================================================================
Date:         Wed, 24 Nov 1993 11:07:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Brian.Day" <[e-mail]>
Subject:      SIGNON ACCESS-L

Please sign me up on the MS Access List.  Thanks
=========================================================================
Date:         Wed, 24 Nov 1993 11:59:47 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Kenneth Hutchinson <[e-mail]>
Subject:      Access Basic

 I have the Access Basic Cookbook, and it has a lot of excelent sample
code. The probem is, he doesn't _explain_ the code very well. Especially
the examples of the Win API calls.
 My question is: Does anyone know any goods books on Access Basic
programming that thoroughly explains Win API calls, or is there a good
Windows programming book that I could use for Access programming instead?
I really have no interest in learning actual Windows programming, but
am interested in some of the hooks you can use through Access Basic.

TIA,
Ken Hutchinson
[e-mail]
=========================================================================
Date:         Wed, 24 Nov 1993 09:47:00 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Kapczynski, Mark" <[e-mail]>
Subject:      Re: Access Basic

Where can I find the Access Basic Cookbook?
 ----------
From: owner-access-l
To: Multiple recipients of list ACCESS-L
Subject: Access Basic
Date: Wed, Nov 24, 1993 11:59AM

 I have the Access Basic Cookbook, and it has a lot of excelent sample
code. The probem is, he doesn't _explain_ the code very well. Especially
the examples of the Win API calls.
 My question is: Does anyone know any goods books on Access Basic
programming that thoroughly explains Win API calls, or is there a good
Windows programming book that I could use for Access programming instead?
I really have no interest in learning actual Windows programming, but
am interested in some of the hooks you can use through Access Basic.

TIA,
Ken Hutchinson
[e-mail]
=========================================================================
Date:         Wed, 24 Nov 1993 13:30:39 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Farr <[e-mail]>
Subject:      Access Basic

Windows Programing for Meer Mortals by
Woody Leonhard may be helpful in starting
you into API calls
   Dave
=========================================================================
Date:         Wed, 24 Nov 1993 13:15:39 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Corey Lawson <[e-mail]>
Subject:      Re: Access Basic
In-Reply-To:  <[e-mail]>; from "Kenneth
              Hutchinson" at Nov 24, 93 11:59 am

Most of the windows programming books use C, but there are a few that
use Visual Basic.  The god-like book (even though it's in C), is by
Petzold (I think it's called "Windows Programming".  Anyways, it's by
Microsoft Press).  Sorry I don't know more names.  I would say the
Windows programming books that use Visual Basic are going to be a lot
easier to use than the C books.

>  I have the Access Basic Cookbook, and it has a lot of excelent sample
> code. The probem is, he doesn't _explain_ the code very well. Especially
> the examples of the Win API calls.

That's because he's assuming that, if you are going to be using api calls,
that you are a windows programmer.  A safe assumption (you can hose your
system if you don't know what you are doing...), but irritating for
you.  I got some cool WordBasic macros that had some funky API calls, and
it got me to buy a couple of Windows programming books, because I wanted
to know how they worked.

>  My question is: Does anyone know any goods books on Access Basic
> programming that thoroughly explains Win API calls, or is there a good
> Windows programming book that I could use for Access programming instead?
> I really have no interest in learning actual Windows programming, but
> am interested in some of the hooks you can use through Access Basic.

Well, like WordBasic and using "Declare ...", once you start making API
calls, you ARE doing Windows programming...

Hope this helps...
-Corey Lawson
[e-mail]

> TIA,
> Ken Hutchinson
> [e-mail]
>
=========================================================================
Date:         Thu, 25 Nov 1993 10:52:31 MET
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Niels Abrahamsen <[e-mail]>
Subject:      subscribe

Hi, everybody,
I have got this address from a friend of mine and would like
to subsribe to this list. My name is Eduard Petrovsky, home
e-mail address [e-mail], but now, till the end
of November at [e-mail]
I am writing because in creating a database in Access, I encounter
few problems which I did not find in the newsgroup archive.

1. in macros, the RunCode action is run also in conditional
branching using ... as an ellipse, although the condition is
not matched. Use RunMacro instead, and in this macro use the
RunCode action, followed by StopAllMacros.

2. in designing Report in a mailing labels format, I wanted to
include an option to skip over several labels and start the printing
at certain print area at a page. However, the MoveLayout command
(in a function attached to the OnFormat Property) runs only once,
whatever I did to run it several times. Therefore, you can skip
only the first position.

If anybody knows solution to the latter problem, please, let me know
at [e-mail]

Thanks, Eduard
=========================================================================
Date:         Thu, 25 Nov 1993 11:56:38 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Louis Jezsik <[e-mail]>
Subject:      Research Reference Database

I downloaded two Access files from CICA that deal with publications
research.  Unfortunately the really fancy one is written in German.
I suspect that it is exactly what I am looking for but it's kind of
hard to tell.  Does anyone know of other files that can assist me
with my research?
Thanks
Louis
[e-mail]
=========================================================================
Date:         Sat, 27 Nov 1993 17:28:44 -0500
Reply-To:     "Patrick J. Duddy" <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "Patrick J. Duddy" <[e-mail]>
Subject:      Enumerated Types in Access?

Hello:
        I am a beginner user of Access, not into the programming end of it
even though I am a CIS (programming) student at my school. Here is the
problem definition:

        I would like to create an 'enumerated type' in a sense, on the
Database I am using at my workplace.  We are doing an inventory of our
PC's here, and there are a few elements I would like in the database that
I am not sure how to format.
        For each PC, certain attributes or inventory items are to be
stored.  The example I am stuck on is Disk Drive Types, but it would apply
to things like 'what Software is installed?' and 'Which
servers/minicomputers is the PC connected to?'.
        I would like to have an enumerated type, such that my form would
have either
            a) Check Boxes for each of a few choices (5 drive types) {it
could be handled, of course, with just yes/no values for each item.}
            b) A text box that would hold only those items selected that
happen to belong on that CPU.  (40 software packages, but each PC has less
than 10 of those selected for each--yes/no values would not work on a form
since 40 check boxes would not fit on the form I need).

        I have created tables of things like Drive Types and Software
Packages that look like this:

        key #           name
        1               5-1/4"
        2               3-1/2"
        3               720K
        4               CD ROM
        5               Tape Backup


        So I don't want to just enter a text box with the listing of
attributes for the PC.  What do I need to do to accomplish the above?

        Did I explain it well enough?  Send questions, comments, and
references if need be.  Thanks for your time.  :-)


                        Rob Duddy
=========================================================================
Date:         Sun, 28 Nov 1993 17:53:58 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Enumerated Types in Access?
In-Reply-To:  <[e-mail]> from "Patrick J. Duddy" at Nov
              27, 93 05:28:44 pm

Rob,

As an Access guy, and not a comupter science guy, I would approach your
problem as follows:

1) Use subform, from your main computer form to capture data on the disk
   drives and software.  Use combo-boxes on the subform to bring up a
   of acceptable drives or software.  Set the bound column of the combo
   box to the column # of the key field.

2) Don't worry about enumerated types.  Don't think you need them for
   this situation.

3) You will have to use two subforms to get this data.  One for the disk
   drives (one->many, cpu's->drives). One for software. One for network
   attachments. (funny, I count 3 subforms now!)

Good luck.

John
=========================================================================
Date:         Mon, 29 Nov 1993 09:03:56 EST
Reply-To:     [e-mail]
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Pekka Koskinen <[e-mail]>
Subject:      Access PD

What is a good ftp-site to find some access public domain stuff?

I know this has een discussed here before, so you may as well e-mail me
personally.

G'day and thanks in advance!
Pekka

*****************************************************************************
 Pekka Koskinen             :)
 CIMO, P.O. Box 343         :)       "To thine own self be true -;
 00531 Helsinki, FINLAND    :)  And it must follow as the night the day;
 tel [phone]    :)    Thou canst not be false to any man"
 fax [phone]    :)           William Shakespeare
=========================================================================
Date:         Mon, 29 Nov 1993 09:10:00 EST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         David Long <mvgsd![e-mail]>
Subject:      Re: Enumerated Types in Access?

Patrick,
Re: Softwares
I would probably create a separate table as a list of all possible
softwares, and since no machine has more than ten softwares installed,
create on your form ten text boxes w/drop down lists. The list will
be based on the software table.....and all you have to do is select
the software(s) from the list.

Hope this helps
==============================================================================
  David B. Long                             E-Mail=> [e-mail]
  AT&T Network Systems (N.Andover MA.)      or=> [e-mail]
  Quality Engineering                       Tele=> 508-960-3683
==============================================================================
=========================================================================
Date:         Mon, 29 Nov 1993 08:49:07 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         "John A. Olson" <[e-mail]>
Subject:      error code generator

This is perhaps a repeat for some of you, but Kevin Anderson requested that
it be made public.
It was originally posted by John von Colditz.

The following Access BASIC code will list the error codes for you.  It
is from the Access Basic Cookbook by Chris St. Valentine.  It creates a
text file of the error codes.  You just need to modify it to create a
table.

( Actually, I just imported it into a table after running it.  Quite simple
really. )

Function UsedErrors() as Integer

     Dim FileNumber as Integer, T as String, X as Long

     T = Chr$(9)
     X = O
     FileNumber = FreeFile
     On Error Resume Next
     Open"ERRORS.TXT" For Output As FileNumber
     If Err Then
          UsedErrors = False
     Else
          Do While True
                X = X + 1
                If Left(Error(X), 18) <> "User-defined error" then
                     If Err Then
                          Exit Do
                     Endif
                     Print #FileNumber, X; T; Error(X)
                Endif
          Loop
          Close FileNumber
          UsedErrors = True
     End If
     On Error GoTo 0
End Function
=========================================================================
Date:         Mon, 29 Nov 1993 21:21:19 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Louis Jezsik <[e-mail]>
Subject:      Data Input form

<I'm kinda new to this, bear with me.)

I have three tables: Publications (containing information about various
publications I am researching), Institutions (about the Institutions
where I obtained the publications) and Contacts (about the people who
led me to the publications.  I want to create a form that will allow
me to enter information into each table.  Unfortunately, Access wants
to base the form on a single table rather than letting me choose from
the three.  I have tried to create a query that contained the information
I want (thereby allowing me to create a form with the three tables) but
I can't get Access to open the sheet (the query is blank, so then is the
form!).  What am I doing wrong?

Thanks!
Louis Jezsik
[e-mail]
=========================================================================
Date:         Mon, 29 Nov 1993 22:06:02 -0600
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Jenny Jacobson <[e-mail]>
Subject:      Request:  How to OLE from ACCESS to WordPerfect 6

I'm going to have several documents in WordPerfect 6.  I'd like to
have the objects stored in ACCESS and the links stored in the documents.
WordPerfect 6 does not include Microsoft ACCESS as one of its database
formats.  I realize that an ASCII delimited file could be used.  However,
I'm hoping there is an easier way.

Jenny Jacobson
[e-mail]
=========================================================================
Date:         Mon, 29 Nov 1993 21:50:05 -0800
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         John von Colditz <[e-mail]>
Subject:      Re: Data Input form
In-Reply-To:  <[e-mail]> from "Louis Jezsik" at Nov 29,
              93 09:21:19 pm

Louis,

What I _think_ you want to do is actually a two-step process.  From the
way you described it, Publication and Institutions are related one-one.
If so, create a query that builds this list.  Let's assume the key field
linking these tables will be PubNum.  So you have to add an intermediate
table in this relationship, composed of PubNum, and the key for the
contact database.  You end up with something like:

Publications      Intermediate       Institutions
PubNum ------------> PubNum
PubJunk....          InstCode ------> InstCode
                                      InstName
                                      InstJunk

Use this query to build your form for the input of publication and
institution information.

For the input of your Contact information, you need to build a form,
based on the table where you will store contact information.  It will
probably look something like:

PubNum
ContactCode
OtherStuff...

Better yet, base it on a query that links your contact information to
your contact table:

PubNum
ContactCode -----------> ContactCode
OtherStuff....           ContactName
                         OtherContactStuff

After the form is built, you will want to set it up as a subform on the
Publications form.  The easiest way is to bring the Publications form up
in design mode, click on the icon for the Contact form with the right
mouse button, hold it down, and drag it to the Publications form.  For
the LinkChild and LinkMaster Fields use PubNum.

This may all seem quite confusing.  For more information (that may be
clearer!) see chapter 10 in the Access Users Guide or look it up in a
good book on Access.

Good luck.

John
[e-mail]
=========================================================================
Date:         Tue, 30 Nov 1993 06:40:03 PST
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Tri M Pham <[e-mail]>
Subject:      Linking MS Write File to Access.

   Hello,

I am very new to Access and Window. So, if this is a FAQ please tell me where I
can get the answers. I have tried to link a MS Write file to access and
been uncessful at it. I did:

- Choose EDIT then Insert Object.
- Another screen is displayed with only MS Graph, Package, Paintbrush Picture
  and Sound.
- When I select File (button), I get the list of many other applications
  including MS Write.
- When I selected the file that I wanted, I got a error message:
  "Invalid source application name".

I have tried help and the system tell me to register the application but so
far I am unsuccessful. What am I doing wrong? Please help. Thank you very
much for your assistance.

   Regards,

   Tri Pham
=========================================================================
Date:         Tue, 30 Nov 1993 10:22:04 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      Startup size & location of OLE applications...

When opening another application (such as MS-Word) by double-clicking
on an OLE field, is there any way to cause that application to start in a
certain sized window and at a pre-determined location? ...some technique
that would affect an OLE application the same as the MOVESIZE action
does on an ACCESS object?

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
|                         o__                                          |
| Steve Bratten          _.>/^_      BITNET < GE0793@SIUCVMB >         |
| Graduate School       (_) \(_)   INTERNET < [e-mail] > |
| Southern Illinois University                                         |
| Carbondale IL 62901-4716   \o  \o  \o   Graduate School              |
| Voice: [phone]       |>  |>  |>  Southern Illinois University |
|   Fax: [phone]      < \ < \ < \  Carbondale, IL  62901-4716   |
|                                                                      |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date:         Tue, 30 Nov 1993 15:55:32 -0500
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Steve Bratten <[e-mail]>
Subject:      Finding differences between two tables...

I'm forwarding this message for a colleague who doesn't have access to
the network.
Steve Bratten

I have a problem I am hoping you can help me with. I have two tables A
and B. A has a list of names. B has the same list of names, but more.
What I need to do is make a query that will show me only the names not
on list A. Also, if there is a way, could there be a query that would
show the differences between two tables? Say only showing the items not
equal in both tables.

Thanks,
Roger Davis
=========================================================================
Date:         Wed, 1 Dec 1993 10:51:24 GMT+1300
Reply-To:     Microsoft Access Database Discussion List
              <[e-mail]>
Sender:       Microsoft Access Database Discussion List
              <[e-mail]>
From:         Daniel Bar-Even <[e-mail]>
Organization: National Library of New Zealand
Subject:      Re: Finding differences between two tables...

<Stuff Deleted>

>I have a problem I am hoping you can help me with. I have two tables
>A and B. A has a list of names. B has the same list of names, but
>more. What I need to do is make a query that will show me only the
>names not on list A. Also, if there is a way, could there be a query
>that would show the differences between two tables? Say only showing
>the items not equal in both tables.

>Thanks,
>Roger Davis

You need to create an "Outer Join". In your query, create a join
between the Name fields in table A and Table B.  Double click on the
join line and choose the option that selects all the records in table
A and only those in B which are equal.

Then select all the Name records in table A which aren't in table B.

Eg:
SELECT Blah Blah
FROM Blah Blah
WHERE A.Name Not In (B.NAME)

You can create another query the other way around to show all the
records in B which aren't in A but I don't know how to show the
differences between the two tables in one query (I'm sure someone on
the list knows a way...).

**********************************************************
Daniel Bar-Even   ([e-mail])
Client Support Analyst
National Library of New Zealand
Te Puna Matauranga o Aotearoa
P.O. Box 1467
Wellington
New Zealand         Ph: [phone]  Fax: [phone]
**********************************************************